package interfaz;

import dominio.*;
import integracion.*;
import java.awt.Component;
import java.io.IOException;
import java.sql.Date;
import java.sql.SQLException;
import java.sql.Time;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;


public class insumos_inventarios extends javax.swing.JFrame {

    ControlEmpleado controlEmpleado;
    ControlEvento controlEvento;
    ControlClienteParticular controlClientePart;
    ControlClienteCompania controlClienteComp;
    ControlEmpleadoClientePart controlEmpleadoClientePart;
    ControlEmpleadoClienteComp controlEmpleadoClienteComp;
    ControlCotizacion controlCotizacion;
    private Component aviso;

    public insumos_inventarios() {
        initComponents();
        this.setLocation(210, 10);
    }

    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        buttonGroup1 = new javax.swing.ButtonGroup();
        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel1 = new javax.swing.JPanel();
        jPanel6 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        tablaEjecutivos = new javax.swing.JTable();
        mostrarEjecutivos = new javax.swing.JButton();
        jPanel8 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        cedula = new javax.swing.JTextField();
        nombre = new javax.swing.JTextField();
        apellido = new javax.swing.JTextField();
        telefono = new javax.swing.JTextField();
        salario = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        jLabel16 = new javax.swing.JLabel();
        limpiar = new javax.swing.JButton();
        insertarEjecutivo = new javax.swing.JButton();
        jPanel9 = new javax.swing.JPanel();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        cedulas = new javax.swing.JComboBox();
        nombreEjecutivo = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jLabel42 = new javax.swing.JLabel();
        jLabel43 = new javax.swing.JLabel();
        jLabel44 = new javax.swing.JLabel();
        salarioEjecutivo = new javax.swing.JLabel();
        telefonoEjecutivo = new javax.swing.JLabel();
        apellidoEjecutivo = new javax.swing.JLabel();
        eliminarEjecutivo = new javax.swing.JButton();
        jPanel10 = new javax.swing.JPanel();
        jLabel9 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();
        jLabel15 = new javax.swing.JLabel();
        cedulas2 = new javax.swing.JComboBox();
        nombre2 = new javax.swing.JTextField();
        apellido2 = new javax.swing.JTextField();
        telefono2 = new javax.swing.JTextField();
        salario2 = new javax.swing.JTextField();
        checkNombre = new javax.swing.JCheckBox();
        checkApellido = new javax.swing.JCheckBox();
        checkTelefono = new javax.swing.JCheckBox();
        checkSalario = new javax.swing.JCheckBox();
        jLabel17 = new javax.swing.JLabel();
        insertarEjecutivo1 = new javax.swing.JButton();
        jPanel2 = new javax.swing.JPanel();
        jPanel11 = new javax.swing.JPanel();
        jScrollPane2 = new javax.swing.JScrollPane();
        tablaContratados = new javax.swing.JTable();
        mostrarContratados = new javax.swing.JButton();
        jPanel12 = new javax.swing.JPanel();
        jLabel18 = new javax.swing.JLabel();
        jLabel19 = new javax.swing.JLabel();
        jLabel20 = new javax.swing.JLabel();
        jLabel21 = new javax.swing.JLabel();
        jLabel22 = new javax.swing.JLabel();
        cedulaC = new javax.swing.JTextField();
        nombreC = new javax.swing.JTextField();
        apellidoC = new javax.swing.JTextField();
        telefonoC = new javax.swing.JTextField();
        cargo = new javax.swing.JTextField();
        jLabel23 = new javax.swing.JLabel();
        jLabel24 = new javax.swing.JLabel();
        jLabel35 = new javax.swing.JLabel();
        costo = new javax.swing.JTextField();
        limpiar1 = new javax.swing.JButton();
        insertarEjecutivo2 = new javax.swing.JButton();
        jPanel13 = new javax.swing.JPanel();
        jLabel25 = new javax.swing.JLabel();
        jLabel26 = new javax.swing.JLabel();
        cedulasC = new javax.swing.JComboBox();
        nombreContratado = new javax.swing.JLabel();
        jLabel27 = new javax.swing.JLabel();
        jLabel37 = new javax.swing.JLabel();
        apellidoContratado = new javax.swing.JLabel();
        jLabel38 = new javax.swing.JLabel();
        telefonoContratado = new javax.swing.JLabel();
        jLabel39 = new javax.swing.JLabel();
        cargoContratado = new javax.swing.JLabel();
        jLabel40 = new javax.swing.JLabel();
        costoContratado = new javax.swing.JLabel();
        eliminarEjecutivo1 = new javax.swing.JButton();
        jPanel14 = new javax.swing.JPanel();
        jLabel28 = new javax.swing.JLabel();
        jLabel29 = new javax.swing.JLabel();
        jLabel30 = new javax.swing.JLabel();
        jLabel31 = new javax.swing.JLabel();
        jLabel32 = new javax.swing.JLabel();
        jLabel33 = new javax.swing.JLabel();
        cedulasC2 = new javax.swing.JComboBox();
        nombreC2 = new javax.swing.JTextField();
        apellidoC2 = new javax.swing.JTextField();
        telefonoC2 = new javax.swing.JTextField();
        cargo2 = new javax.swing.JTextField();
        checkNombreC = new javax.swing.JCheckBox();
        checkApellidoC = new javax.swing.JCheckBox();
        checkTelefonoC = new javax.swing.JCheckBox();
        checkCargo = new javax.swing.JCheckBox();
        jLabel34 = new javax.swing.JLabel();
        jLabel36 = new javax.swing.JLabel();
        costo2 = new javax.swing.JTextField();
        checkCosto = new javax.swing.JCheckBox();
        insertarEjecutivo3 = new javax.swing.JButton();
        jPanel3 = new javax.swing.JPanel();
        jPanel15 = new javax.swing.JPanel();
        jScrollPane3 = new javax.swing.JScrollPane();
        tablaEventos = new javax.swing.JTable();
        mostrarContratados1 = new javax.swing.JButton();
        jPanel16 = new javax.swing.JPanel();
        jLabel45 = new javax.swing.JLabel();
        jLabel46 = new javax.swing.JLabel();
        jLabel47 = new javax.swing.JLabel();
        jLabel48 = new javax.swing.JLabel();
        descripcionEvento = new javax.swing.JTextField();
        jLabel49 = new javax.swing.JLabel();
        jLabel50 = new javax.swing.JLabel();
        jLabel51 = new javax.swing.JLabel();
        dia = new javax.swing.JComboBox();
        mes = new com.toedter.calendar.JMonthChooser();
        ano = new com.toedter.calendar.JYearChooser();
        horaInicioEvento = new javax.swing.JComboBox();
        horaFinEvento = new javax.swing.JComboBox();
        limpiar4 = new javax.swing.JButton();
        insertarEjecutivo4 = new javax.swing.JButton();
        cedulaEvento = new javax.swing.JComboBox();
        jPanel17 = new javax.swing.JPanel();
        jLabel52 = new javax.swing.JLabel();
        jLabel53 = new javax.swing.JLabel();
        idEventos = new javax.swing.JComboBox();
        fechaLabel = new javax.swing.JLabel();
        jLabel54 = new javax.swing.JLabel();
        jLabel55 = new javax.swing.JLabel();
        descripcionLabel = new javax.swing.JLabel();
        jLabel56 = new javax.swing.JLabel();
        horaInicioLabel = new javax.swing.JLabel();
        jLabel57 = new javax.swing.JLabel();
        horaFinLabel = new javax.swing.JLabel();
        jLabel58 = new javax.swing.JLabel();
        cedEventoLabel = new javax.swing.JLabel();
        eliminarEvento = new javax.swing.JButton();
        jPanel18 = new javax.swing.JPanel();
        jLabel59 = new javax.swing.JLabel();
        jLabel60 = new javax.swing.JLabel();
        jLabel61 = new javax.swing.JLabel();
        jLabel62 = new javax.swing.JLabel();
        jLabel63 = new javax.swing.JLabel();
        jLabel64 = new javax.swing.JLabel();
        descripcion2 = new javax.swing.JTextField();
        horaInicio2 = new javax.swing.JTextField();
        horaFin2 = new javax.swing.JTextField();
        checkFechaE = new javax.swing.JCheckBox();
        checkDescripcionE = new javax.swing.JCheckBox();
        checkHoraInicioE = new javax.swing.JCheckBox();
        checkHoraFinE = new javax.swing.JCheckBox();
        jLabel65 = new javax.swing.JLabel();
        jLabel66 = new javax.swing.JLabel();
        checkCedulaE = new javax.swing.JCheckBox();
        idEventos2 = new javax.swing.JComboBox();
        ModificarEvento = new javax.swing.JButton();
        cedulaEjec2 = new javax.swing.JComboBox();
        diaEve2 = new javax.swing.JComboBox();
        mesEve2 = new com.toedter.calendar.JMonthChooser();
        anoEve2 = new com.toedter.calendar.JYearChooser();
        salir = new javax.swing.JButton();
        jMenuBar1 = new javax.swing.JMenuBar();
        archivo = new javax.swing.JMenu();
        nuevaCotizacion = new javax.swing.JMenuItem();
        informacionSistema = new javax.swing.JMenuItem();
        jSeparator1 = new javax.swing.JSeparator();
        exit = new javax.swing.JMenuItem();
        jMenu1 = new javax.swing.JMenu();
        acercaDe = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("Informacion del sistema");
        setResizable(false);

        jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel6.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));

        tablaEjecutivos.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Id", "Nombre", "Categoria"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.String.class, java.lang.Integer.class
            };
            boolean[] canEdit = new boolean [] {
                false, false, false
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane1.setViewportView(tablaEjecutivos);

        mostrarEjecutivos.setText("Mostrar");
        mostrarEjecutivos.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                mostrarEjecutivosActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel6Layout = new org.jdesktop.layout.GroupLayout(jPanel6);
        jPanel6.setLayout(jPanel6Layout);
        jPanel6Layout.setHorizontalGroup(
            jPanel6Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel6Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel6Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 770, Short.MAX_VALUE)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, mostrarEjecutivos))
                .addContainerGap())
        );
        jPanel6Layout.setVerticalGroup(
            jPanel6Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel6Layout.createSequentialGroup()
                .addContainerGap()
                .add(jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 242, Short.MAX_VALUE)
                .add(11, 11, 11)
                .add(mostrarEjecutivos)
                .addContainerGap())
        );

        jPanel8.setBorder(javax.swing.BorderFactory.createTitledBorder("Insertar Ejecutivo"));
        jPanel8.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12)); // NOI18N

        jLabel1.setText("(*) Cedula:");

        jLabel2.setText("(*) Nombre:");

        jLabel3.setText("(*) Apellido:");

        jLabel4.setText("(*) Telefono:");

        jLabel5.setText("(*) Salario:");

        nombre.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                nombreActionPerformed(evt);
            }
        });

        apellido.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                apellidoActionPerformed(evt);
            }
        });

        salario.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                salarioActionPerformed(evt);
            }
        });

        jLabel6.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/edit_add.png"))); // NOI18N

        jLabel16.setFont(new java.awt.Font("Tahoma", 0, 10));
        jLabel16.setForeground(new java.awt.Color(255, 0, 0));
        jLabel16.setText("Campos obligatorios (*)");

        limpiar.setText("Limpiar");
        limpiar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                limpiarActionPerformed(evt);
            }
        });

        insertarEjecutivo.setText("Insertar");
        insertarEjecutivo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                insertarEjecutivoActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel8Layout = new org.jdesktop.layout.GroupLayout(jPanel8);
        jPanel8.setLayout(jPanel8Layout);
        jPanel8Layout.setHorizontalGroup(
            jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel8Layout.createSequentialGroup()
                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                    .add(jPanel8Layout.createSequentialGroup()
                        .add(jLabel6)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jLabel16))
                    .add(jPanel8Layout.createSequentialGroup()
                        .add(19, 19, 19)
                        .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel8Layout.createSequentialGroup()
                                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                                    .add(jLabel1)
                                    .add(jLabel2))
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED))
                            .add(jPanel8Layout.createSequentialGroup()
                                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                    .add(jLabel3)
                                    .add(jLabel4)
                                    .add(jLabel5))
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)))
                        .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                            .add(salario, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 136, Short.MAX_VALUE)
                            .add(telefono, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 136, Short.MAX_VALUE)
                            .add(apellido, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 136, Short.MAX_VALUE)
                            .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                                .add(nombre)
                                .add(cedula, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 136, Short.MAX_VALUE)))))
                .addContainerGap(20, Short.MAX_VALUE))
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel8Layout.createSequentialGroup()
                .addContainerGap(90, Short.MAX_VALUE)
                .add(limpiar)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(insertarEjecutivo)
                .addContainerGap())
        );

        jPanel8Layout.linkSize(new java.awt.Component[] {jLabel1, jLabel2, jLabel3, jLabel4, jLabel5}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel8Layout.linkSize(new java.awt.Component[] {insertarEjecutivo, limpiar}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel8Layout.setVerticalGroup(
            jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel8Layout.createSequentialGroup()
                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel6)
                    .add(jLabel16))
                .add(18, 18, 18)
                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jLabel1)
                    .add(jPanel8Layout.createSequentialGroup()
                        .add(cedula, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(10, 10, 10)
                        .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel2)
                            .add(nombre, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel3)
                    .add(apellido, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel4)
                    .add(telefono, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel5)
                    .add(salario, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 32, Short.MAX_VALUE)
                .add(jPanel8Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(limpiar)
                    .add(insertarEjecutivo))
                .addContainerGap())
        );

        jPanel8Layout.linkSize(new java.awt.Component[] {apellido, cedula, nombre, salario, telefono}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel9.setBorder(javax.swing.BorderFactory.createTitledBorder("Eliminar Ejecutivo"));

        jLabel7.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/edit_remove.png"))); // NOI18N

        jLabel8.setText("Cedula:");

        cedulas.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cedulasActionPerformed(evt);
            }
        });

        nombreEjecutivo.setText("Nombre ejecutivo");

        jLabel10.setText("Nombre:");

        jLabel42.setText("Apellido:");

        jLabel43.setText("Telefono:");

        jLabel44.setText("Salario:");

        salarioEjecutivo.setText("Salario ejecutivo");

        telefonoEjecutivo.setText("Telefono ejecutivo");

        apellidoEjecutivo.setText("Apellido ejecutivo");

        eliminarEjecutivo.setText("Eliminar");
        eliminarEjecutivo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                eliminarEjecutivoActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel9Layout = new org.jdesktop.layout.GroupLayout(jPanel9);
        jPanel9.setLayout(jPanel9Layout);
        jPanel9Layout.setHorizontalGroup(
            jPanel9Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel9Layout.createSequentialGroup()
                .addContainerGap()
                .add(jLabel7)
                .addContainerGap(222, Short.MAX_VALUE))
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel9Layout.createSequentialGroup()
                .addContainerGap(175, Short.MAX_VALUE)
                .add(eliminarEjecutivo)
                .addContainerGap())
            .add(jPanel9Layout.createSequentialGroup()
                .add(34, 34, 34)
                .add(jPanel9Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel9Layout.createSequentialGroup()
                        .add(jLabel8)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(cedulas, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 129, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                    .add(jPanel9Layout.createSequentialGroup()
                        .add(jLabel10)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(nombreEjecutivo))
                    .add(jPanel9Layout.createSequentialGroup()
                        .add(jLabel42)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(apellidoEjecutivo))
                    .add(jPanel9Layout.createSequentialGroup()
                        .add(jLabel43)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(telefonoEjecutivo))
                    .add(jPanel9Layout.createSequentialGroup()
                        .add(jLabel44)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(salarioEjecutivo)))
                .addContainerGap(41, Short.MAX_VALUE))
        );

        jPanel9Layout.linkSize(new java.awt.Component[] {apellidoEjecutivo, nombreEjecutivo, salarioEjecutivo, telefonoEjecutivo}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel9Layout.linkSize(new java.awt.Component[] {jLabel10, jLabel42, jLabel43, jLabel44, jLabel8}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel9Layout.setVerticalGroup(
            jPanel9Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel9Layout.createSequentialGroup()
                .add(jLabel7)
                .add(14, 14, 14)
                .add(jPanel9Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel8)
                    .add(cedulas, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel9Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(nombreEjecutivo)
                    .add(jLabel10))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel9Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel42)
                    .add(apellidoEjecutivo))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel9Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(telefonoEjecutivo)
                    .add(jLabel43))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel9Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(salarioEjecutivo)
                    .add(jLabel44))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 35, Short.MAX_VALUE)
                .add(eliminarEjecutivo)
                .addContainerGap())
        );

        jPanel9Layout.linkSize(new java.awt.Component[] {cedulas, jLabel10, jLabel42, jLabel43, jLabel44, jLabel8}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel10.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Modificar Ejecutivo", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Microsoft Sans Serif", 0, 12))); // NOI18N

        jLabel9.setText("Cedula:");

        jLabel11.setText("Nombre:");

        jLabel12.setText("Apellido:");

        jLabel13.setText("Telefono:");

        jLabel14.setText("Salario:");

        jLabel15.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/configure.png"))); // NOI18N

        cedulas2.setPreferredSize(new java.awt.Dimension(11, 20));
        cedulas2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cedulas2ActionPerformed(evt);
            }
        });

        nombre2.setEnabled(false);

        apellido2.setEnabled(false);

        telefono2.setEnabled(false);

        salario2.setEnabled(false);

        checkNombre.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        checkNombre.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkNombreActionPerformed(evt);
            }
        });

        checkApellido.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        checkApellido.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkApellidoActionPerformed(evt);
            }
        });

        checkTelefono.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        checkTelefono.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkTelefonoActionPerformed(evt);
            }
        });

        checkSalario.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        checkSalario.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkSalarioActionPerformed(evt);
            }
        });

        jLabel17.setFont(new java.awt.Font("Tahoma", 0, 10));
        jLabel17.setText("Seleccione los campos que desea modificar");

        insertarEjecutivo1.setText("Modificar");
        insertarEjecutivo1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                insertarEjecutivo1ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel10Layout = new org.jdesktop.layout.GroupLayout(jPanel10);
        jPanel10.setLayout(jPanel10Layout);
        jPanel10Layout.setHorizontalGroup(
            jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel10Layout.createSequentialGroup()
                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel10Layout.createSequentialGroup()
                        .addContainerGap()
                        .add(jLabel15)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jLabel17))
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel10Layout.createSequentialGroup()
                        .add(25, 25, 25)
                        .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                                .add(jLabel14)
                                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                    .add(jLabel9)
                                    .add(jLabel13)))
                            .add(jLabel11)
                            .add(jLabel12))
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jPanel10Layout.createSequentialGroup()
                                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                                    .add(jPanel10Layout.createSequentialGroup()
                                        .add(nombre2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 128, Short.MAX_VALUE)
                                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                        .add(checkNombre))
                                    .add(jPanel10Layout.createSequentialGroup()
                                        .add(apellido2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 128, Short.MAX_VALUE)
                                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                        .add(checkApellido))
                                    .add(org.jdesktop.layout.GroupLayout.LEADING, jPanel10Layout.createSequentialGroup()
                                        .add(telefono2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 127, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                        .add(checkTelefono))
                                    .add(org.jdesktop.layout.GroupLayout.LEADING, jPanel10Layout.createSequentialGroup()
                                        .add(salario2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 127, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                        .add(checkSalario)))
                                .add(10, 10, 10))
                            .add(cedulas2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 127, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, insertarEjecutivo1))
                .addContainerGap())
        );

        jPanel10Layout.linkSize(new java.awt.Component[] {apellido2, cedulas2, nombre2, salario2, telefono2}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel10Layout.linkSize(new java.awt.Component[] {jLabel11, jLabel12, jLabel13, jLabel14, jLabel9}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel10Layout.setVerticalGroup(
            jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel10Layout.createSequentialGroup()
                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel15)
                    .add(jLabel17))
                .add(18, 18, 18)
                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(cedulas2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel9))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(nombre2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(checkNombre)
                    .add(jLabel11))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(apellido2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(checkApellido)
                    .add(jLabel12))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(telefono2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(checkTelefono)
                    .add(jLabel13))
                .add(11, 11, 11)
                .add(jPanel10Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(salario2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(checkSalario)
                    .add(jLabel14))
                .add(18, 18, 18)
                .add(insertarEjecutivo1)
                .addContainerGap(18, Short.MAX_VALUE))
        );

        jPanel10Layout.linkSize(new java.awt.Component[] {apellido2, cedulas2, checkApellido, checkNombre, checkSalario, checkTelefono, nombre2, salario2, telefono2}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel10Layout.linkSize(new java.awt.Component[] {jLabel11, jLabel12, jLabel13, jLabel14, jLabel9}, org.jdesktop.layout.GroupLayout.VERTICAL);

        org.jdesktop.layout.GroupLayout jPanel1Layout = new org.jdesktop.layout.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel6, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .add(jPanel1Layout.createSequentialGroup()
                        .add(jPanel8, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel9, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel10, 0, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
                .add(18, 18, 18))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel6, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel8, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .add(jPanel10, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .add(jPanel9, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );

        jPanel1Layout.linkSize(new java.awt.Component[] {jPanel10, jPanel8, jPanel9}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel8.getAccessibleContext().setAccessibleName("opop");

        jTabbedPane1.addTab("Insumos", jPanel1);

        jPanel11.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel11.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        jPanel11.setPreferredSize(new java.awt.Dimension(810, 283));

        tablaContratados.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Id", "Nombre"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.String.class
            };
            boolean[] canEdit = new boolean [] {
                false, false
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane2.setViewportView(tablaContratados);

        mostrarContratados.setText("Mostrar");
        mostrarContratados.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                mostrarContratadosActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel11Layout = new org.jdesktop.layout.GroupLayout(jPanel11);
        jPanel11.setLayout(jPanel11Layout);
        jPanel11Layout.setHorizontalGroup(
            jPanel11Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel11Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel11Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jScrollPane2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 778, Short.MAX_VALUE)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, mostrarContratados))
                .addContainerGap())
        );
        jPanel11Layout.setVerticalGroup(
            jPanel11Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel11Layout.createSequentialGroup()
                .addContainerGap()
                .add(jScrollPane2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 243, Short.MAX_VALUE)
                .add(11, 11, 11)
                .add(mostrarContratados, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 23, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

        jPanel12.setBorder(javax.swing.BorderFactory.createTitledBorder("Insertar Contratado"));
        jPanel12.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        jPanel12.setPreferredSize(new java.awt.Dimension(272, 270));

        jLabel18.setText("(*) Cedula:");

        jLabel19.setText("(*) Nombre:");

        jLabel20.setText("(*) Apellido:");

        jLabel21.setText("(*) Telefono:");

        jLabel22.setText("(*) Cargo:");

        nombreC.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                nombreCActionPerformed(evt);
            }
        });

        apellidoC.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                apellidoCActionPerformed(evt);
            }
        });

        cargo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cargoActionPerformed(evt);
            }
        });

        jLabel23.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/edit_add.png"))); // NOI18N

        jLabel24.setFont(new java.awt.Font("Tahoma", 0, 10));
        jLabel24.setForeground(new java.awt.Color(255, 0, 0));
        jLabel24.setText("Campos obligatorios (*)");

        jLabel35.setText("(*) Costo Hora:");

        costo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                costoActionPerformed(evt);
            }
        });

        limpiar1.setText("Limpiar");
        limpiar1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                limpiar1ActionPerformed(evt);
            }
        });

        insertarEjecutivo2.setText("Insertar");
        insertarEjecutivo2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                insertarEjecutivo2ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel12Layout = new org.jdesktop.layout.GroupLayout(jPanel12);
        jPanel12.setLayout(jPanel12Layout);
        jPanel12Layout.setHorizontalGroup(
            jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel12Layout.createSequentialGroup()
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel12Layout.createSequentialGroup()
                        .add(1, 1, 1)
                        .add(jLabel23)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jLabel24))
                    .add(jPanel12Layout.createSequentialGroup()
                        .addContainerGap()
                        .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jLabel35)
                            .add(jLabel22)
                            .add(jLabel21)
                            .add(jLabel20)
                            .add(jLabel19)
                            .add(jLabel18))
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                                .add(cargo)
                                .add(telefonoC)
                                .add(apellidoC)
                                .add(nombreC)
                                .add(cedulaC))
                            .add(costo, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 142, Short.MAX_VALUE)
                            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel12Layout.createSequentialGroup()
                                .add(limpiar1)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(insertarEjecutivo2)))
                        .add(77, 77, 77)))
                .add(16, 16, 16))
        );

        jPanel12Layout.linkSize(new java.awt.Component[] {jLabel18, jLabel19, jLabel20, jLabel21, jLabel22, jLabel35}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel12Layout.linkSize(new java.awt.Component[] {insertarEjecutivo2, limpiar1}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel12Layout.linkSize(new java.awt.Component[] {apellidoC, cargo, cedulaC, costo, nombreC, telefonoC}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel12Layout.setVerticalGroup(
            jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel12Layout.createSequentialGroup()
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel23)
                    .add(jLabel24))
                .add(13, 13, 13)
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(cedulaC, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel18))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(nombreC, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel19))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(apellidoC, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel20))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(telefonoC, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel21))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(cargo, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel22))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(costo, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel35))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 24, Short.MAX_VALUE)
                .add(jPanel12Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(limpiar1)
                    .add(insertarEjecutivo2))
                .addContainerGap())
        );

        jPanel12Layout.linkSize(new java.awt.Component[] {jLabel18, jLabel19, jLabel20, jLabel21, jLabel22, jLabel35}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel13.setBorder(javax.swing.BorderFactory.createTitledBorder("Eliminar Contratado"));
        jPanel13.setPreferredSize(new java.awt.Dimension(272, 270));

        jLabel25.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/edit_remove.png"))); // NOI18N

        jLabel26.setText("Cedula:");

        cedulasC.setPreferredSize(new java.awt.Dimension(11, 20));
        cedulasC.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cedulasCActionPerformed(evt);
            }
        });

        nombreContratado.setText("nombre contratado");

        jLabel27.setText("Nombre:");

        jLabel37.setText("Apellido:");

        apellidoContratado.setText("apellido contratado");

        jLabel38.setText("Telefono:");

        telefonoContratado.setText("telefono contratado");

        jLabel39.setText("Cargo:");

        cargoContratado.setText("cargo contratado");

        jLabel40.setText("Costo:");

        costoContratado.setText("costo contratado");

        eliminarEjecutivo1.setText("Eliminar");
        eliminarEjecutivo1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                eliminarEjecutivo1ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel13Layout = new org.jdesktop.layout.GroupLayout(jPanel13);
        jPanel13.setLayout(jPanel13Layout);
        jPanel13Layout.setHorizontalGroup(
            jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel13Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jLabel25)
                    .add(jPanel13Layout.createSequentialGroup()
                        .add(jLabel27)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(nombreContratado))
                    .add(jPanel13Layout.createSequentialGroup()
                        .add(jLabel37)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(apellidoContratado))
                    .add(jPanel13Layout.createSequentialGroup()
                        .add(jLabel38)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(telefonoContratado))
                    .add(jPanel13Layout.createSequentialGroup()
                        .add(jLabel39)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(cargoContratado))
                    .add(jPanel13Layout.createSequentialGroup()
                        .add(jLabel40)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(costoContratado))
                    .add(jPanel13Layout.createSequentialGroup()
                        .add(jLabel26)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(cedulasC, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 149, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(41, Short.MAX_VALUE))
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel13Layout.createSequentialGroup()
                .addContainerGap(173, Short.MAX_VALUE)
                .add(eliminarEjecutivo1)
                .addContainerGap())
        );

        jPanel13Layout.linkSize(new java.awt.Component[] {jLabel26, jLabel27, jLabel37, jLabel38, jLabel39, jLabel40}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel13Layout.linkSize(new java.awt.Component[] {apellidoContratado, cargoContratado, cedulasC, costoContratado, nombreContratado, telefonoContratado}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel13Layout.setVerticalGroup(
            jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel13Layout.createSequentialGroup()
                .add(jLabel25)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel26)
                    .add(cedulasC, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(nombreContratado)
                    .add(jLabel27))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(apellidoContratado)
                    .add(jLabel37))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(telefonoContratado)
                    .add(jLabel38))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(cargoContratado)
                    .add(jLabel39))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel13Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(costoContratado)
                    .add(jLabel40))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 36, Short.MAX_VALUE)
                .add(eliminarEjecutivo1)
                .addContainerGap())
        );

        jPanel13Layout.linkSize(new java.awt.Component[] {jLabel26, jLabel27, jLabel37, jLabel38, jLabel39, jLabel40}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel14.setBorder(javax.swing.BorderFactory.createTitledBorder("Modificar Contratado"));
        jPanel14.setPreferredSize(new java.awt.Dimension(272, 270));

        jLabel28.setText("Cedula:");

        jLabel29.setText("Nombre:");

        jLabel30.setText("Apellido:");

        jLabel31.setText("Telefono:");

        jLabel32.setText("Cargo:");

        jLabel33.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/configure.png"))); // NOI18N

        cedulasC2.setPreferredSize(new java.awt.Dimension(11, 20));
        cedulasC2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cedulasC2ActionPerformed(evt);
            }
        });

        nombreC2.setEnabled(false);

        apellidoC2.setEnabled(false);

        telefonoC2.setEnabled(false);

        cargo2.setEnabled(false);

        checkNombreC.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkNombreCActionPerformed(evt);
            }
        });

        checkApellidoC.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkApellidoCActionPerformed(evt);
            }
        });

        checkTelefonoC.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkTelefonoCActionPerformed(evt);
            }
        });

        checkCargo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkCargoActionPerformed(evt);
            }
        });

        jLabel34.setFont(new java.awt.Font("Tahoma", 0, 10));
        jLabel34.setText("Seleccione los campos que desea modificar");

        jLabel36.setText("Costo:");

        costo2.setEnabled(false);

        checkCosto.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkCostoActionPerformed(evt);
            }
        });

        insertarEjecutivo3.setText("Modificar");
        insertarEjecutivo3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                insertarEjecutivo3ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel14Layout = new org.jdesktop.layout.GroupLayout(jPanel14);
        jPanel14.setLayout(jPanel14Layout);
        jPanel14Layout.setHorizontalGroup(
            jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel14Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                        .add(jPanel14Layout.createSequentialGroup()
                            .add(jLabel33)
                            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                            .add(jLabel34))
                        .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel14Layout.createSequentialGroup()
                            .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                .add(jPanel14Layout.createSequentialGroup()
                                    .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                        .add(jLabel32)
                                        .add(jLabel36))
                                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                    .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                        .add(jPanel14Layout.createSequentialGroup()
                                            .add(costo2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 154, Short.MAX_VALUE)
                                            .add(2, 2, 2))
                                        .add(jPanel14Layout.createSequentialGroup()
                                            .add(cargo2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 154, Short.MAX_VALUE)
                                            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)))
                                    .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                                        .add(checkCosto)
                                        .add(checkCargo)))
                                .add(jPanel14Layout.createSequentialGroup()
                                    .add(jLabel31)
                                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                    .add(telefonoC2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 154, Short.MAX_VALUE)
                                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                    .add(checkTelefonoC))
                                .add(jPanel14Layout.createSequentialGroup()
                                    .add(jLabel30)
                                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                    .add(apellidoC2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 154, Short.MAX_VALUE)
                                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                    .add(checkApellidoC))
                                .add(jPanel14Layout.createSequentialGroup()
                                    .add(jLabel29)
                                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                    .add(nombreC2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 154, Short.MAX_VALUE)
                                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                    .add(checkNombreC))
                                .add(jPanel14Layout.createSequentialGroup()
                                    .add(jLabel28)
                                    .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                    .add(cedulasC2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 152, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                            .addContainerGap()))
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel14Layout.createSequentialGroup()
                        .add(insertarEjecutivo3)
                        .addContainerGap())))
        );

        jPanel14Layout.linkSize(new java.awt.Component[] {jLabel28, jLabel29, jLabel30, jLabel31, jLabel32, jLabel36}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel14Layout.linkSize(new java.awt.Component[] {apellidoC2, cargo2, cedulasC2, costo2, nombreC2, telefonoC2}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel14Layout.setVerticalGroup(
            jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel14Layout.createSequentialGroup()
                .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel33)
                    .add(jLabel34))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(cedulasC2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel28))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(nombreC2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel29)
                    .add(checkNombreC))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(apellidoC2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel30)
                    .add(checkApellidoC))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(telefonoC2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel31)
                    .add(checkTelefonoC))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(cargo2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel32)
                    .add(checkCargo))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel14Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(costo2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel36)
                    .add(checkCosto))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 25, Short.MAX_VALUE)
                .add(insertarEjecutivo3)
                .addContainerGap())
        );

        jPanel14Layout.linkSize(new java.awt.Component[] {jLabel28, jLabel29, jLabel30, jLabel31, jLabel32, jLabel36}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel14Layout.linkSize(new java.awt.Component[] {apellidoC2, cargo2, cedulasC2, costo2, nombreC2, telefonoC2}, org.jdesktop.layout.GroupLayout.VERTICAL);

        org.jdesktop.layout.GroupLayout jPanel2Layout = new org.jdesktop.layout.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel2Layout.createSequentialGroup()
                        .add(jPanel11, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addContainerGap())
                    .add(jPanel2Layout.createSequentialGroup()
                        .add(jPanel12, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 264, Short.MAX_VALUE)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel13, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 264, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel14, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 264, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(16, 16, 16))))
        );

        jPanel2Layout.linkSize(new java.awt.Component[] {jPanel12, jPanel13, jPanel14}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel11, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 312, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel12, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .add(jPanel13, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .add(jPanel14, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );

        jPanel2Layout.linkSize(new java.awt.Component[] {jPanel12, jPanel13, jPanel14}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jTabbedPane1.addTab("Categorias", jPanel2);

        jPanel15.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel15.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        jPanel15.setPreferredSize(new java.awt.Dimension(810, 283));

        tablaEventos.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Id", "Fecha", "Descripcion", "Hora Inicio", "Hora Fin", "Cedula Ejecutivo"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane3.setViewportView(tablaEventos);

        mostrarContratados1.setText("Mostrar");
        mostrarContratados1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                mostrarContratados1ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel15Layout = new org.jdesktop.layout.GroupLayout(jPanel15);
        jPanel15.setLayout(jPanel15Layout);
        jPanel15Layout.setHorizontalGroup(
            jPanel15Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel15Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel15Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jScrollPane3, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 772, Short.MAX_VALUE)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, mostrarContratados1))
                .addContainerGap())
        );
        jPanel15Layout.setVerticalGroup(
            jPanel15Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel15Layout.createSequentialGroup()
                .addContainerGap()
                .add(jScrollPane3, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 240, Short.MAX_VALUE)
                .add(11, 11, 11)
                .add(mostrarContratados1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 23, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

        jPanel16.setBorder(javax.swing.BorderFactory.createTitledBorder("Insertar Eventos"));
        jPanel16.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        jPanel16.setPreferredSize(new java.awt.Dimension(272, 270));

        jLabel45.setText("(*) Fecha:");

        jLabel46.setText("(*) Descripcion:");

        jLabel47.setText("(*) Hora Inicio:");

        jLabel48.setText("(*) Hora Fin:");

        descripcionEvento.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                descripcionEventoActionPerformed(evt);
            }
        });

        jLabel49.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/edit_add.png"))); // NOI18N

        jLabel50.setFont(new java.awt.Font("Tahoma", 0, 10));
        jLabel50.setForeground(new java.awt.Color(255, 0, 0));
        jLabel50.setText("Campos obligatorios (*)");

        jLabel51.setText("(*) Cedula Ejec:");

        dia.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));

        mes.setFont(new java.awt.Font("Tahoma", 0, 11));

        horaInicioEvento.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "00:00:00", "01:00:00", "02:00:00", "03:00:00", "04:00:00", "05:00:00", "06:00:00", "07:00:00", "08:00:00", "09:00:00", "10:00:00", "11:00:00", "12:00:00", "13:00:00", "14:00:00", "15:00:00", "16:00:00", "17:00:00", "18:00:00", "19:00:00", "20:00:00", "21:00:00", "22:00:00", "23:00:00", "24:00:00" }));
        horaInicioEvento.setPreferredSize(new java.awt.Dimension(68, 20));

        horaFinEvento.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "00:00:00", "01:00:00", "02:00:00", "03:00:00", "04:00:00", "05:00:00", "06:00:00", "07:00:00", "08:00:00", "09:00:00", "10:00:00", "11:00:00", "12:00:00", "13:00:00", "14:00:00", "15:00:00", "16:00:00", "17:00:00", "18:00:00", "19:00:00", "20:00:00", "21:00:00", "22:00:00", "23:00:00", "24:00:00" }));
        horaFinEvento.setPreferredSize(new java.awt.Dimension(68, 20));

        limpiar4.setText("Limpiar");
        limpiar4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                limpiar4ActionPerformed(evt);
            }
        });

        insertarEjecutivo4.setText("Insertar");
        insertarEjecutivo4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                insertarEjecutivo4ActionPerformed(evt);
            }
        });

        cedulaEvento.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cedulaEventoActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel16Layout = new org.jdesktop.layout.GroupLayout(jPanel16);
        jPanel16.setLayout(jPanel16Layout);
        jPanel16Layout.setHorizontalGroup(
            jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel16Layout.createSequentialGroup()
                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel16Layout.createSequentialGroup()
                        .add(1, 1, 1)
                        .add(jLabel49)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jLabel50))
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel16Layout.createSequentialGroup()
                        .addContainerGap()
                        .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                            .add(org.jdesktop.layout.GroupLayout.LEADING, jPanel16Layout.createSequentialGroup()
                                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                    .add(jLabel48)
                                    .add(jLabel47)
                                    .add(jLabel46)
                                    .add(jLabel51))
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                    .add(horaInicioEvento, 0, 138, Short.MAX_VALUE)
                                    .add(descripcionEvento, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 138, Short.MAX_VALUE)
                                    .add(horaFinEvento, 0, 138, Short.MAX_VALUE)
                                    .add(cedulaEvento, 0, 138, Short.MAX_VALUE))
                                .add(8, 8, 8))
                            .add(org.jdesktop.layout.GroupLayout.LEADING, jPanel16Layout.createSequentialGroup()
                                .add(jLabel45)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                                    .add(ano, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 138, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                    .add(jPanel16Layout.createSequentialGroup()
                                        .add(dia, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                        .add(mes, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))))
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)))
                .add(15, 15, 15))
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel16Layout.createSequentialGroup()
                .addContainerGap(94, Short.MAX_VALUE)
                .add(limpiar4)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(insertarEjecutivo4)
                .addContainerGap())
        );

        jPanel16Layout.linkSize(new java.awt.Component[] {insertarEjecutivo4, limpiar4}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel16Layout.linkSize(new java.awt.Component[] {ano, descripcionEvento, horaFinEvento, horaInicioEvento}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel16Layout.linkSize(new java.awt.Component[] {jLabel45, jLabel46, jLabel47, jLabel48, jLabel51}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel16Layout.setVerticalGroup(
            jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel16Layout.createSequentialGroup()
                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel49)
                    .add(jLabel50))
                .add(16, 16, 16)
                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jLabel45)
                    .add(dia, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 16, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(mes, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .add(7, 7, 7)
                .add(ano, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(descripcionEvento, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel46))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel47)
                    .add(horaInicioEvento, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel48)
                    .add(horaFinEvento, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 21, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel51)
                    .add(cedulaEvento, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 22, Short.MAX_VALUE)
                .add(jPanel16Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(limpiar4)
                    .add(insertarEjecutivo4))
                .addContainerGap())
        );

        jPanel16Layout.linkSize(new java.awt.Component[] {ano, descripcionEvento, dia, mes}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel17.setBorder(javax.swing.BorderFactory.createTitledBorder("Eliminar Evento"));
        jPanel17.setPreferredSize(new java.awt.Dimension(272, 270));

        jLabel52.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/edit_remove.png"))); // NOI18N

        jLabel53.setText("Id:");

        idEventos.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                idEventosActionPerformed(evt);
            }
        });

        fechaLabel.setText("fecha evento");

        jLabel54.setText("Fecha:");

        jLabel55.setText("Descripcion:");

        descripcionLabel.setText("descripcion evento");

        jLabel56.setText("Hora Inicio:");

        horaInicioLabel.setText("hora inicio evento");

        jLabel57.setText("Hora Fin:");

        horaFinLabel.setText("hora fin evento");

        jLabel58.setText("Cedula Ejec.:");

        cedEventoLabel.setText("cedula del ejecutivo");

        eliminarEvento.setText("Eliminar");
        eliminarEvento.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                eliminarEventoActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel17Layout = new org.jdesktop.layout.GroupLayout(jPanel17);
        jPanel17.setLayout(jPanel17Layout);
        jPanel17Layout.setHorizontalGroup(
            jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel17Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel17Layout.createSequentialGroup()
                        .add(10, 10, 10)
                        .add(jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jPanel17Layout.createSequentialGroup()
                                .add(jLabel54)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(fechaLabel))
                            .add(jPanel17Layout.createSequentialGroup()
                                .add(jLabel55)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(descripcionLabel))
                            .add(jPanel17Layout.createSequentialGroup()
                                .add(jLabel56)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(horaInicioLabel))
                            .add(jPanel17Layout.createSequentialGroup()
                                .add(jLabel57)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(horaFinLabel))
                            .add(jPanel17Layout.createSequentialGroup()
                                .add(jLabel58)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(cedEventoLabel))
                            .add(jPanel17Layout.createSequentialGroup()
                                .add(jLabel53)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(idEventos, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 122, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))))
                    .add(jLabel52))
                .addContainerGap(42, Short.MAX_VALUE))
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel17Layout.createSequentialGroup()
                .addContainerGap(173, Short.MAX_VALUE)
                .add(eliminarEvento)
                .addContainerGap())
        );

        jPanel17Layout.linkSize(new java.awt.Component[] {jLabel53, jLabel54, jLabel55, jLabel56, jLabel57, jLabel58}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel17Layout.linkSize(new java.awt.Component[] {cedEventoLabel, descripcionLabel, fechaLabel, horaFinLabel, horaInicioLabel}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel17Layout.setVerticalGroup(
            jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel17Layout.createSequentialGroup()
                .add(jLabel52)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel53)
                    .add(idEventos, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(fechaLabel)
                    .add(jLabel54))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(descripcionLabel)
                    .add(jLabel55))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(horaInicioLabel)
                    .add(jLabel56))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(horaFinLabel)
                    .add(jLabel57))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel17Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(cedEventoLabel)
                    .add(jLabel58))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 39, Short.MAX_VALUE)
                .add(eliminarEvento)
                .addContainerGap())
        );

        jPanel17Layout.linkSize(new java.awt.Component[] {jLabel53, jLabel54, jLabel55, jLabel56, jLabel57, jLabel58}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jPanel18.setBorder(javax.swing.BorderFactory.createTitledBorder("Modificar Evento"));
        jPanel18.setPreferredSize(new java.awt.Dimension(272, 270));

        jLabel59.setText("Id:");

        jLabel60.setText("Fecha:");

        jLabel61.setText("Descripcion:");

        jLabel62.setText("Hora Inicio:");

        jLabel63.setText("Hora Fin:");

        jLabel64.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/configure.png"))); // NOI18N

        descripcion2.setEnabled(false);

        horaInicio2.setEnabled(false);

        horaFin2.setEnabled(false);

        checkFechaE.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkFechaEActionPerformed(evt);
            }
        });

        checkDescripcionE.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkDescripcionEActionPerformed(evt);
            }
        });

        checkHoraInicioE.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkHoraInicioEActionPerformed(evt);
            }
        });

        checkHoraFinE.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkHoraFinEActionPerformed(evt);
            }
        });

        jLabel65.setFont(new java.awt.Font("Tahoma", 0, 10));
        jLabel65.setText("Seleccione los campos que desea modificar");

        jLabel66.setText("Cedula Ejec.:");

        checkCedulaE.setFont(new java.awt.Font("Microsoft Sans Serif", 0, 12));
        checkCedulaE.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                checkCedulaEActionPerformed(evt);
            }
        });

        idEventos2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                idEventos2ActionPerformed(evt);
            }
        });

        ModificarEvento.setText("Modificar");
        ModificarEvento.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                ModificarEventoActionPerformed(evt);
            }
        });

        cedulaEjec2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cedulaEjec2ActionPerformed(evt);
            }
        });

        diaEve2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));
        diaEve2.setEnabled(false);
        diaEve2.setPreferredSize(new java.awt.Dimension(36, 20));

        mesEve2.setEnabled(false);
        mesEve2.setFont(new java.awt.Font("Tahoma", 0, 11));
        mesEve2.setPreferredSize(new java.awt.Dimension(92, 20));

        anoEve2.setEnabled(false);
        anoEve2.setPreferredSize(new java.awt.Dimension(42, 20));

        org.jdesktop.layout.GroupLayout jPanel18Layout = new org.jdesktop.layout.GroupLayout(jPanel18);
        jPanel18.setLayout(jPanel18Layout);
        jPanel18Layout.setHorizontalGroup(
            jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel18Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel18Layout.createSequentialGroup()
                        .add(jLabel64)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jLabel65)
                        .add(11, 11, 11))
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel18Layout.createSequentialGroup()
                        .add(ModificarEvento)
                        .addContainerGap())
                    .add(jPanel18Layout.createSequentialGroup()
                        .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                                .add(jLabel61)
                                .add(jLabel62)
                                .add(jLabel63)
                                .add(jLabel66))
                            .add(jLabel59)
                            .add(jLabel60))
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jPanel18Layout.createSequentialGroup()
                                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                    .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                                        .add(jPanel18Layout.createSequentialGroup()
                                            .add(diaEve2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                            .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                            .add(mesEve2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                                        .add(idEventos2, 0, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                                    .add(anoEve2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 134, Short.MAX_VALUE))
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                                .add(checkFechaE)
                                .add(13, 13, 13))
                            .add(jPanel18Layout.createSequentialGroup()
                                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                                    .add(horaInicio2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 71, Short.MAX_VALUE)
                                    .add(horaFin2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 93, Short.MAX_VALUE)
                                    .add(cedulaEjec2, 0, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .add(descripcion2))
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                    .add(checkDescripcionE)
                                    .add(checkHoraInicioE)
                                    .add(checkHoraFinE)
                                    .add(checkCedulaE))
                                .addContainerGap(13, Short.MAX_VALUE))))))
        );

        jPanel18Layout.linkSize(new java.awt.Component[] {jLabel59, jLabel60, jLabel61, jLabel62, jLabel63, jLabel66}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel18Layout.linkSize(new java.awt.Component[] {anoEve2, cedulaEjec2, descripcion2, horaFin2, horaInicio2, idEventos2}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel18Layout.setVerticalGroup(
            jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel18Layout.createSequentialGroup()
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel64)
                    .add(jLabel65))
                .add(18, 18, 18)
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(idEventos2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel59))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(mesEve2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                        .add(diaEve2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(jLabel60)))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(anoEve2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(checkFechaE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 6, Short.MAX_VALUE)
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(descripcion2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel61)
                    .add(checkDescripcionE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(horaInicio2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel62)
                    .add(checkHoraInicioE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(horaFin2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel63)
                    .add(checkHoraFinE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel18Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel66)
                    .add(checkCedulaE)
                    .add(cedulaEjec2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(ModificarEvento)
                .addContainerGap())
        );

        jPanel18Layout.linkSize(new java.awt.Component[] {jLabel59, jLabel60, jLabel61, jLabel62, jLabel63, jLabel66}, org.jdesktop.layout.GroupLayout.VERTICAL);

        org.jdesktop.layout.GroupLayout jPanel3Layout = new org.jdesktop.layout.GroupLayout(jPanel3);
        jPanel3.setLayout(jPanel3Layout);
        jPanel3Layout.setHorizontalGroup(
            jPanel3Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel3Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel15, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 804, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jPanel3Layout.createSequentialGroup()
                        .add(jPanel16, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 264, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel17, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 264, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jPanel18, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 264, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(16, Short.MAX_VALUE))
        );

        jPanel3Layout.linkSize(new java.awt.Component[] {jPanel16, jPanel17, jPanel18}, org.jdesktop.layout.GroupLayout.HORIZONTAL);

        jPanel3Layout.setVerticalGroup(
            jPanel3Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel15, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 309, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.UNRELATED)
                .add(jPanel3Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel16, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 273, Short.MAX_VALUE)
                    .add(jPanel17, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 273, Short.MAX_VALUE)
                    .add(jPanel18, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 273, Short.MAX_VALUE))
                .addContainerGap())
        );

        jPanel3Layout.linkSize(new java.awt.Component[] {jPanel16, jPanel17, jPanel18}, org.jdesktop.layout.GroupLayout.VERTICAL);

        jTabbedPane1.addTab("Inventario", jPanel3);

        salir.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/exit.png"))); // NOI18N
        salir.setText("Salir");
        salir.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                salirActionPerformed(evt);
            }
        });

        archivo.setText("Archivo");

        nuevaCotizacion.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_C, java.awt.event.InputEvent.CTRL_MASK));
        nuevaCotizacion.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/add.png"))); // NOI18N
        nuevaCotizacion.setText("Nueva Cotizacion...");
        nuevaCotizacion.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                nuevaCotizacionActionPerformed(evt);
            }
        });
        archivo.add(nuevaCotizacion);

        informacionSistema.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_S, java.awt.event.InputEvent.CTRL_MASK));
        informacionSistema.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/database.png"))); // NOI18N
        informacionSistema.setText("Informacion del Sistema...");
        informacionSistema.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                informacionSistemaActionPerformed(evt);
            }
        });
        archivo.add(informacionSistema);
        archivo.add(jSeparator1);

        exit.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_E, java.awt.event.InputEvent.CTRL_MASK));
        exit.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/exit.png"))); // NOI18N
        exit.setText("Salir");
        exit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                exitActionPerformed(evt);
            }
        });
        archivo.add(exit);

        jMenuBar1.add(archivo);

        jMenu1.setText("Ayuda");

        acercaDe.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_A, java.awt.event.InputEvent.CTRL_MASK));
        acercaDe.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Iconos/info.png"))); // NOI18N
        acercaDe.setText("Acerca de MDJ");
        acercaDe.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                acercaDeActionPerformed(evt);
            }
        });
        jMenu1.add(acercaDe);

        jMenuBar1.add(jMenu1);

        setJMenuBar(jMenuBar1);

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(772, 772, 772)
                .add(salir)
                .addContainerGap())
            .add(org.jdesktop.layout.GroupLayout.TRAILING, layout.createSequentialGroup()
                .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .add(jTabbedPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 835, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(org.jdesktop.layout.GroupLayout.TRAILING, layout.createSequentialGroup()
                .addContainerGap()
                .add(jTabbedPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 648, Short.MAX_VALUE)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(salir)
                .addContainerGap())
        );

        jTabbedPane1.getAccessibleContext().setAccessibleName("");

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void nuevaCotizacionActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_nuevaCotizacionActionPerformed
        NuevaCotizacion cot = null;
        try {
            cot = new NuevaCotizacion();
        } catch (SQLException ex) {
            Logger.getLogger(Principal.class.getName()).log(Level.SEVERE, null, ex);
        }
        cot.setVisible(true);
}//GEN-LAST:event_nuevaCotizacionActionPerformed

    private void informacionSistemaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_informacionSistemaActionPerformed
        insumos_inventarios info = new insumos_inventarios();
        info.setVisible(true);
}//GEN-LAST:event_informacionSistemaActionPerformed

    private void exitActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_exitActionPerformed
int resultado = JOptionPane.showConfirmDialog(null, "Esta seguro que desea realizar esta operacion?", "ATENCION", JOptionPane.OK_CANCEL_OPTION);
    if (resultado==0){
        System.exit(0);
    }
}//GEN-LAST:event_exitActionPerformed

    private void salirActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_salirActionPerformed
int resultado = JOptionPane.showConfirmDialog(null, "Esta seguro que desea salir del sistema?", "ATENCION", JOptionPane.OK_CANCEL_OPTION);
    if (resultado==0){
        System.exit(0);
    }
}//GEN-LAST:event_salirActionPerformed

    private void acercaDeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_acercaDeActionPerformed
    About ab = new About();
    ab.setVisible(true);
    }//GEN-LAST:event_acercaDeActionPerformed

    private void cedulaEjec2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cedulaEjec2ActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_cedulaEjec2ActionPerformed

    private void ModificarEventoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ModificarEventoActionPerformed
        int resultado = JOptionPane.showConfirmDialog(null, "Esta seguro que desea realizar esta operacion?", "ATENCION", JOptionPane.OK_CANCEL_OPTION);

        if (resultado==0){
            try {
                controlEvento = new ControlEvento();
                List<Evento> eventos = controlEvento.consultarEventos();
                Integer Id = Integer.parseInt(idEventos2.getSelectedItem().toString());

                for (Iterator iter = eventos.iterator(); iter.hasNext(); ) {
                    Evento eve = (Evento) iter.next();

                    if(eve.getIdEvento().equals(Id)){

                        if(checkFechaE.isSelected()){
                            String day = diaEve2.getSelectedItem().toString();
                            String month = String.valueOf(mesEve2.getMonth()+1);
                            String year = String.valueOf(anoEve2.getYear());

                            String Fecha = year + "-" + month + "-" + day;
                            Date fechaEvento = Date.valueOf(Fecha);
                            eve.setFecha(fechaEvento);
                        }

                        if(checkDescripcionE.isSelected()){
                            eve.setDescripcion(descripcion2.getText());
                        }

                        if(checkHoraInicioE.isSelected()){
                            eve.setHoraInicio(Time.valueOf(horaInicio2.getText()));
                        }

                        if(checkHoraFinE.isSelected()){
                            eve.setHoraFin(Time.valueOf(horaFin2.getText()));
                        }

                        if(checkCedulaE.isSelected()){
                            eve.setEjecutivoCedula(Integer.parseInt(cedulaEjec2.getSelectedItem().toString()));
                        }

                        boolean result = controlEvento.modificarEvento(eve);
                        eventos = controlEvento.consultarEventos();

                        if(result){
                            this.cargarTablaEventos(eventos);
                            this.asignarLabelEventos(eventos);
                            JOptionPane.showMessageDialog(aviso,"El evento ha sido modificado con Exito","Nota", 1);
                        }else{
                            JOptionPane.showMessageDialog(aviso,"El evento no pudo ser modificado","Nota", 1);
                        }
                    }
                }
            } catch (IOException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            } catch (SQLException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
}//GEN-LAST:event_ModificarEventoActionPerformed

    private void idEventos2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_idEventos2ActionPerformed
        try {
            controlEvento = new ControlEvento();
            List<Evento> eventos = controlEvento.consultarEventos();

            if(idEventos2.getItemCount()!=0){
                Integer Id = Integer.parseInt(idEventos2.getSelectedItem().toString());

                for (int i=0;i<eventos.size();i++){

                    if(eventos.get(i).getIdEvento().equals(Id)){

                        String[] date = eventos.get(i).getFecha().toString().split("-");
                        String Year = date[0];
                        String Month = date[1];
                        String Day = date[2];

                        diaEve2.setSelectedItem(Day);
                        mesEve2.setMonth(Integer.parseInt(Month)-1);
                        anoEve2.setYear(Integer.parseInt(Year));

                        descripcion2.setText(eventos.get(i).getDescripcion());
                        horaInicio2.setText(eventos.get(i).getHoraInicio().toString());
                        horaFin2.setText(eventos.get(i).getHoraFin().toString());
                        cedulaEjec2.setSelectedItem(eventos.get(i).getEjecutivoCedula());
                    }
                }
                diaEve2.setEnabled(false);
                mesEve2.setEnabled(false);
                anoEve2.setEnabled(false);
                descripcion2.setEnabled(false);
                horaInicio2.setEnabled(false);
                horaFin2.setEnabled(false);
                cedulaEjec2.setEnabled(false);

                checkFechaE.setSelected(false);
                checkDescripcionE.setSelected(false);
                checkHoraInicioE.setSelected(false);
                checkHoraFinE.setSelected(false);
                checkCedulaE.setSelected(false);
            }

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_idEventos2ActionPerformed

    private void checkCedulaEActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkCedulaEActionPerformed
        if(checkCedulaE.isSelected()){
            cedulaEjec2.setEnabled(true);
        }else{
            cedulaEjec2.setEnabled(false);
        }

        try{
            if(idEventos2.getItemCount()!=0){
                controlEvento = new ControlEvento();
                List<Evento> eventos = controlEvento.consultarEventos();
                Integer Id = Integer.parseInt(idEventos2.getSelectedItem().toString());

                for (Iterator iter = eventos.iterator(); iter.hasNext(); ) {
                    Evento eve = (Evento) iter.next();

                    if(eve.getIdEvento().equals(Id)){
                        if(!checkCedulaE.isSelected()){
                            cedulaEjec2.setSelectedItem(eve.getEjecutivoCedula().toString());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkCedulaEActionPerformed

    private void checkHoraFinEActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkHoraFinEActionPerformed
        if(checkHoraFinE.isSelected()){
            horaFin2.setEnabled(true);
        }else{
            horaFin2.setEnabled(false);
        }

        try{
            if(idEventos2.getItemCount()!=0){
                controlEvento = new ControlEvento();
                List<Evento> eventos = controlEvento.consultarEventos();
                Integer Id = Integer.parseInt(idEventos2.getSelectedItem().toString());

                for (Iterator iter = eventos.iterator(); iter.hasNext(); ) {
                    Evento eve = (Evento) iter.next();

                    if(eve.getIdEvento().equals(Id)){
                        if(!checkHoraFinE.isSelected()){
                            horaFin2.setText(eve.getHoraFin().toString());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkHoraFinEActionPerformed

    private void checkHoraInicioEActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkHoraInicioEActionPerformed
        if(checkHoraInicioE.isSelected()){
            horaInicio2.setEnabled(true);
        }else{
            horaInicio2.setEnabled(false);
        }

        try{
            if(idEventos2.getItemCount()!=0){
                controlEvento = new ControlEvento();
                List<Evento> eventos = controlEvento.consultarEventos();
                Integer Id = Integer.parseInt(idEventos2.getSelectedItem().toString());

                for (Iterator iter = eventos.iterator(); iter.hasNext(); ) {
                    Evento eve = (Evento) iter.next();

                    if(eve.getIdEvento().equals(Id)){
                        if(!checkHoraInicioE.isSelected()){
                            horaInicio2.setText(eve.getHoraInicio().toString());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkHoraInicioEActionPerformed

    private void checkDescripcionEActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkDescripcionEActionPerformed
        if(checkDescripcionE.isSelected()){
            descripcion2.setEnabled(true);
        }else{
            descripcion2.setEnabled(false);
        }

        try{
            if(idEventos2.getItemCount()!=0){
                controlEvento = new ControlEvento();
                List<Evento> eventos = controlEvento.consultarEventos();
                Integer Id = Integer.parseInt(idEventos2.getSelectedItem().toString());

                for (Iterator iter = eventos.iterator(); iter.hasNext(); ) {
                    Evento eve = (Evento) iter.next();

                    if(eve.getIdEvento().equals(Id)){
                        if(!checkDescripcionE.isSelected()){
                            descripcion2.setText(eve.getDescripcion());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkDescripcionEActionPerformed

    private void checkFechaEActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkFechaEActionPerformed
        if(checkFechaE.isSelected()){
            diaEve2.setEnabled(true);
            mesEve2.setEnabled(true);
            anoEve2.setEnabled(true);
        }else{
            diaEve2.setEnabled(false);
            mesEve2.setEnabled(false);
            anoEve2.setEnabled(false);
        }

        try{
            if(idEventos2.getItemCount()!=0){
                controlEvento = new ControlEvento();
                List<Evento> eventos = controlEvento.consultarEventos();
                Integer Id = Integer.parseInt(idEventos2.getSelectedItem().toString());

                for (Iterator iter = eventos.iterator(); iter.hasNext(); ) {
                    Evento eve = (Evento) iter.next();

                    if(eve.getIdEvento().equals(Id)){
                        if(!checkFechaE.isSelected()){
                            String[] fecha = eve.getFecha().toString().split("-");

                            diaEve2.setSelectedItem(fecha[2]);
                            mesEve2.setMonth(Integer.parseInt(fecha[1])-1);
                            anoEve2.setYear(Integer.parseInt(fecha[0]));
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkFechaEActionPerformed

    private void eliminarEventoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_eliminarEventoActionPerformed
        int resultado = JOptionPane.showConfirmDialog(null, "Esta seguro que desea realizar esta operacion?", "ATENCION", JOptionPane.OK_CANCEL_OPTION);

        if (resultado==0){
            try {
                controlEvento = new ControlEvento();
                List<Evento> eventos = controlEvento.consultarEventos();
                Integer id = Integer.parseInt(idEventos.getSelectedItem().toString());

                for (int i=0;i<eventos.size();i++){
                    if(eventos.get(i).getIdEvento().equals(id)){
                        boolean result = controlEvento.eliminarEvento(eventos.get(i));
                        eventos = controlEvento.consultarEventos();

                        if (result){
                            idEventos.removeItem(id);
                            this.cargarTablaEventos(eventos);
                            this.cargarIdEventos();
                            JOptionPane.showMessageDialog(aviso,"El evento ha sido eliminado con Exito ","Nota", 1);

                            for(int j=0;j<idEventos2.getItemCount();j++){
                                Integer Id = Integer.parseInt(idEventos2.getItemAt(j).toString());
                                if(Id.equals(id)){
                                    idEventos2.removeItem(id);
                                }
                            }
                        } else{
                            JOptionPane.showMessageDialog(aviso,"El contratado no se pudo eliminar","Nota", 1);
                        }
                    }
                }
            } catch (IOException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            } catch (SQLException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
}//GEN-LAST:event_eliminarEventoActionPerformed

    private void idEventosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_idEventosActionPerformed
        try {
            controlEvento = new ControlEvento();
            List<Evento> eventos = controlEvento.consultarEventos();

            this.asignarLabelEventos(eventos);

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_idEventosActionPerformed

    private void cedulaEventoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cedulaEventoActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_cedulaEventoActionPerformed

    private void insertarEjecutivo4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_insertarEjecutivo4ActionPerformed
        try {
            controlEvento = new ControlEvento();

            if((descripcionEvento.getText().equals(""))){
                JOptionPane.showMessageDialog(aviso,"Debe llenar todos los campos ","Warning", 1);
            }else{

                String day = dia.getSelectedItem().toString();
                String month = String.valueOf(mes.getMonth());
                String year = String.valueOf(ano.getYear());

                String Fecha = year + "-" + month + "-" + day;
                Date FechaEvento = Date.valueOf(Fecha);
                String Descripcion = descripcionEvento.getText();

                Time horaI = Time.valueOf(String.valueOf(horaInicioEvento.getSelectedItem()));
                Time horaF = Time.valueOf(String.valueOf(horaFinEvento.getSelectedItem()));
                Integer cedulaE = Integer.parseInt(cedulaEvento.getSelectedItem().toString());

                Evento evento = new Evento(FechaEvento,Descripcion,"lugar",horaI,horaF,cedulaE);

                boolean result = controlEvento.agregarEvento(evento);
                List<Evento> eventos = controlEvento.consultarEventos();

                if(result){
                    JOptionPane.showMessageDialog(aviso,"El evento ha sido agregado con Exito","Nota", 1);
                    this.cargarTablaEventos(eventos);
                    this.cargarIdEventos();
                }else{
                    JOptionPane.showMessageDialog(aviso,"El evento no pudo ser agregado","Nota", 1);
                }

            }
        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_insertarEjecutivo4ActionPerformed

    private void limpiar4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_limpiar4ActionPerformed
        descripcionEvento.setText("");
}//GEN-LAST:event_limpiar4ActionPerformed

    private void descripcionEventoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_descripcionEventoActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_descripcionEventoActionPerformed

    private void mostrarContratados1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mostrarContratados1ActionPerformed
        try {
            controlEvento = new ControlEvento();
            List<Evento> eventos = controlEvento.consultarEventos();

            this.cargarTablaEventos(eventos);
            this.cargarCedulasEjecutivosEvento();
            this.cargarIdEventos();

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_mostrarContratados1ActionPerformed

    private void insertarEjecutivo3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_insertarEjecutivo3ActionPerformed
        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> contratados = controlEmpleado.consultarContratados();
            Integer Cedula = Integer.parseInt(cedulasC2.getSelectedItem().toString());

            for (Iterator iter = contratados.iterator(); iter.hasNext(); ) {
                Empleado emp = (Empleado) iter.next();

                if(emp.getCedula().equals(Cedula)){

                    if(checkNombreC.isSelected()){
                        emp.setNombre(nombreC2.getText());
                    }

                    if(checkApellidoC.isSelected()){
                        emp.setApellido(apellidoC2.getText());
                    }

                    if(checkTelefonoC.isSelected()){
                        emp.setTelefono(telefonoC2.getText());
                    }

                    if(checkCargo.isSelected()){
                        emp.setCargoContratado(cargo2.getText());
                    }

                    if(checkCosto.isSelected()){
                        emp.setCostoHoraContratado(Double.valueOf(costo2.getText()).doubleValue());
                    }

                    boolean result = controlEmpleado.modificarContratado(emp);
                    contratados = controlEmpleado.consultarContratados();

                    if(result){
                        this.cargarTablaContratados(contratados);
                        this.asignarLabelContratado(contratados);
                        JOptionPane.showMessageDialog(aviso,"El contratado ha sido modificado con Exito","Nota", 1);
                    }else{
                        JOptionPane.showMessageDialog(aviso,"El contratado no pudo ser modificado","Nota", 1);
                    }
                }
            }
        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_insertarEjecutivo3ActionPerformed

    private void checkCostoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkCostoActionPerformed

        if(checkCosto.isSelected()){
            costo2.setEnabled(true);
        }else{
            costo2.setEnabled(false);
        }

        try{
            if(cedulasC2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> contratados = controlEmpleado.consultarContratados();
                Integer Cedula = Integer.parseInt(cedulasC2.getSelectedItem().toString());

                for (Iterator iter = contratados.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkCosto.isSelected()){
                            costo2.setText(Double.toString(emp.getCostoHoraContratado()));
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkCostoActionPerformed

    private void checkCargoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkCargoActionPerformed

        if(checkCargo.isSelected()){
            cargo2.setEnabled(true);
        }else{
            cargo2.setEnabled(false);
        }

        try{
            if(cedulasC2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> contratados = controlEmpleado.consultarContratados();
                Integer Cedula = Integer.parseInt(cedulasC2.getSelectedItem().toString());

                for (Iterator iter = contratados.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkCargo.isSelected()){
                            cargo2.setText(emp.getCargoContratado());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkCargoActionPerformed

    private void checkTelefonoCActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkTelefonoCActionPerformed

        if(checkTelefonoC.isSelected()){
            telefonoC2.setEnabled(true);
        }else{
            telefonoC2.setEnabled(false);
        }

        try{
            if(cedulasC2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> contratados = controlEmpleado.consultarContratados();
                Integer Cedula = Integer.parseInt(cedulasC2.getSelectedItem().toString());

                for (Iterator iter = contratados.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkTelefonoC.isSelected()){
                            telefonoC2.setText(emp.getTelefono());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkTelefonoCActionPerformed

    private void checkApellidoCActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkApellidoCActionPerformed

        if(checkApellidoC.isSelected()){
            apellidoC2.setEnabled(true);
        }else{
            apellidoC2.setEnabled(false);
        }

        try{
            if(cedulasC2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> contratados = controlEmpleado.consultarContratados();
                Integer Cedula = Integer.parseInt(cedulasC2.getSelectedItem().toString());

                for (Iterator iter = contratados.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkApellidoC.isSelected()){
                            apellidoC2.setText(emp.getApellido());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkApellidoCActionPerformed

    private void checkNombreCActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkNombreCActionPerformed
        if(checkNombreC.isSelected()){
            nombreC2.setEnabled(true);
        }else{
            nombreC2.setEnabled(false);
        }

        try{
            if(cedulasC2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> contratados = controlEmpleado.consultarContratados();
                Integer Cedula = Integer.parseInt(cedulasC2.getSelectedItem().toString());

                for (Iterator iter = contratados.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkNombreC.isSelected()){
                            nombreC2.setText(emp.getNombre());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkNombreCActionPerformed

    private void cedulasC2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cedulasC2ActionPerformed
        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> contratados = controlEmpleado.consultarContratados();

            if(cedulasC2.getItemCount()!=0){
                Integer Cedula = Integer.parseInt(cedulasC2.getSelectedItem().toString());

                for (int i=0;i<contratados.size();i++){

                    if(contratados.get(i).getCedula().equals(Cedula)){
                        nombreC2.setText(contratados.get(i).getNombre());
                        apellidoC2.setText(contratados.get(i).getApellido());
                        telefonoC2.setText(contratados.get(i).getTelefono());
                        cargo2.setText(contratados.get(i).getCargoContratado());
                        costo2.setText(Double.toString(contratados.get(i).getCostoHoraContratado()));
                    }
                }
                nombreC2.setEnabled(false);
                apellidoC2.setEnabled(false);
                telefonoC2.setEnabled(false);
                cargo2.setEnabled(false);
                costo2.setEnabled(false);

                checkNombreC.setSelected(false);
                checkApellidoC.setSelected(false);
                checkTelefonoC.setSelected(false);
                checkCargo.setSelected(false);
                checkCosto.setSelected(false);
            }

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_cedulasC2ActionPerformed

    private void eliminarEjecutivo1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_eliminarEjecutivo1ActionPerformed
        int resultado = JOptionPane.showConfirmDialog(null, "Esta seguro que desea realizar esta operacion?", "ATENCION", JOptionPane.OK_CANCEL_OPTION);

        if (resultado==0){
            try {
                controlEmpleado = new ControlEmpleado();
                List<Empleado> contratados = controlEmpleado.consultarContratados();
                Integer Cedula = Integer.parseInt(cedulasC.getSelectedItem().toString());

                for (int i=0;i<contratados.size();i++){
                    if(contratados.get(i).getCedula().equals(Cedula)){
                        boolean result = controlEmpleado.eliminarEmpleado(contratados.get(i));
                        contratados = controlEmpleado.consultarContratados();

                        if (result){
                            cedulasC.removeItem(contratados.get(i).getCedula());
                            this.cargarTablaContratados(contratados);
                            this.cargarCedulasContratados();
                            JOptionPane.showMessageDialog(aviso,"El contratado ha sido eliminado con Exito ","Nota", 1);

                            for(int j=0;j<cedulasC2.getItemCount();j++){
                                Integer ced = Integer.parseInt(cedulasC2.getItemAt(j).toString());
                                if(ced.equals(contratados.get(i).getCedula())){
                                    cedulasC2.removeItem(contratados.get(i).getCedula());
                                }
                            }
                        } else{
                            JOptionPane.showMessageDialog(aviso,"El contratado no se pudo eliminar","Nota", 1);
                        }
                    }
                }
            } catch (IOException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            } catch (SQLException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
}//GEN-LAST:event_eliminarEjecutivo1ActionPerformed

    private void cedulasCActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cedulasCActionPerformed

        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> contratados = controlEmpleado.consultarContratados();

            this.asignarLabelContratado(contratados);

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_cedulasCActionPerformed

    private void insertarEjecutivo2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_insertarEjecutivo2ActionPerformed
        try {
            controlEmpleado = new ControlEmpleado();

            if((cedulaC.getText().equals(""))||(nombreC.getText().equals(""))||(apellidoC.getText().equals(""))||(telefonoC.getText().equals(""))||(cargo.getText().equals(""))||(costo.getText().equals(""))){
                JOptionPane.showMessageDialog(aviso,"Debe llenar todos los campos ","Warning", 1);
            }else{

                Integer Cedula = Integer.parseInt(cedulaC.getText());
                String Nombre = nombreC.getText();
                String Apellido = apellidoC.getText();
                String Telefono = telefonoC.getText();
                String Cargo = cargo.getText();
                double Costo = Double.valueOf(costo.getText()).doubleValue();

                Empleado empleado = new Empleado(Cedula,Nombre,Apellido,Telefono,"contratado",Cargo,Costo);

                boolean result = controlEmpleado.agregarEmpleado(empleado);
                List<Empleado> contratados = controlEmpleado.consultarContratados();

                if(result){
                    JOptionPane.showMessageDialog(aviso,"El contratado ha sido agregado con Exito","Nota", 1);
                    this.cargarTablaContratados(contratados);
                    this.cargarCedulasContratados();
                    cedulasC.addItem(Cedula);
                    cedulasC2.addItem(Cedula);
                }else{
                    JOptionPane.showMessageDialog(aviso,"El contratado no pudo ser agregado","Nota", 1);
                }
            }
        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_insertarEjecutivo2ActionPerformed

    private void limpiar1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_limpiar1ActionPerformed
        cedulaC.setText("");
        nombreC.setText("");
        apellidoC.setText("");
        telefonoC.setText("");
        cargo.setText("");
        costo.setText("");
}//GEN-LAST:event_limpiar1ActionPerformed

    private void costoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_costoActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_costoActionPerformed

    private void cargoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cargoActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_cargoActionPerformed

    private void apellidoCActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_apellidoCActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_apellidoCActionPerformed

    private void nombreCActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_nombreCActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_nombreCActionPerformed

    private void mostrarContratadosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mostrarContratadosActionPerformed
        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> contratados = controlEmpleado.consultarContratados();

            this.cargarTablaContratados(contratados);
            this.cargarCedulasContratados();

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_mostrarContratadosActionPerformed

    private void insertarEjecutivo1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_insertarEjecutivo1ActionPerformed
        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
            Integer Cedula = Integer.parseInt(cedulas2.getSelectedItem().toString());

            for (Iterator iter = ejecutivos.iterator(); iter.hasNext(); ) {
                Empleado emp = (Empleado) iter.next();

                if(emp.getCedula().equals(Cedula)){

                    if(checkNombre.isSelected()){
                        emp.setNombre(nombre2.getText());
                    }

                    if(checkApellido.isSelected()){
                        emp.setApellido(apellido2.getText());
                    }

                    if(checkTelefono.isSelected()){
                        emp.setTelefono(telefono2.getText());
                    }

                    if(checkSalario.isSelected()){
                        emp.setSalarioEjecutivo(Double.valueOf(salario2.getText()).doubleValue());
                    }

                    boolean result = controlEmpleado.modificarEjecutivo(emp);
                    ejecutivos = controlEmpleado.consultarEjecutivos();

                    if(result){
                        this.cargarTablaEjecutivos(ejecutivos);
                        this.asignarLabelEjecutivo(ejecutivos);
                        JOptionPane.showMessageDialog(aviso,"El ejecutivo ha sido modificado con Exito","Nota", 1);
                    }else{
                        JOptionPane.showMessageDialog(aviso,"El ejecutivo no pudo ser modificado","Nota", 1);
                    }
                }
            }

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_insertarEjecutivo1ActionPerformed

    private void checkSalarioActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkSalarioActionPerformed

        if(checkSalario.isSelected()){
            salario2.setEnabled(true);
        }else{
            salario2.setEnabled(false);
        }

        try{
            if(cedulas2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
                Integer Cedula = Integer.parseInt(cedulas2.getSelectedItem().toString());

                for (Iterator iter = ejecutivos.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkSalario.isSelected()){
                            salario2.setText(Double.toString(emp.getSalarioEjecutivo()));
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkSalarioActionPerformed

    private void checkTelefonoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkTelefonoActionPerformed

        if(checkTelefono.isSelected()){
            telefono2.setEnabled(true);
        }else{
            telefono2.setEnabled(false);
        }

        try{
            if(cedulas2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
                Integer Cedula = Integer.parseInt(cedulas2.getSelectedItem().toString());

                for (Iterator iter = ejecutivos.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkTelefono.isSelected()){
                            telefono2.setText(emp.getTelefono());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkTelefonoActionPerformed

    private void checkApellidoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkApellidoActionPerformed

        if(checkApellido.isSelected()){
            apellido2.setEnabled(true);
        }else{
            apellido2.setEnabled(false);
        }

        try{
            if(cedulas2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
                Integer Cedula = Integer.parseInt(cedulas2.getSelectedItem().toString());

                for (Iterator iter = ejecutivos.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkApellido.isSelected()){
                            apellido2.setText(emp.getApellido());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkApellidoActionPerformed

    private void checkNombreActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checkNombreActionPerformed

        if(checkNombre.isSelected()){
            nombre2.setEnabled(true);
        }else{
            nombre2.setEnabled(false);
        }

        try{
            if(cedulas2.getItemCount()!=0){
                controlEmpleado = new ControlEmpleado();
                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
                Integer Cedula = Integer.parseInt(cedulas2.getSelectedItem().toString());

                for (Iterator iter = ejecutivos.iterator(); iter.hasNext(); ) {
                    Empleado emp = (Empleado) iter.next();

                    if(emp.getCedula().equals(Cedula)){
                        if(!checkNombre.isSelected()){
                            nombre2.setText(emp.getNombre());
                        }
                    }
                }
            }
        }catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_checkNombreActionPerformed

    private void cedulas2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cedulas2ActionPerformed

        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();

            if(cedulas2.getItemCount()!=0){
                Integer Cedula = Integer.parseInt(cedulas2.getSelectedItem().toString());

                for (int i=0;i<ejecutivos.size();i++){

                    if(ejecutivos.get(i).getCedula().equals(Cedula)){
                        nombre2.setText(ejecutivos.get(i).getNombre());
                        apellido2.setText(ejecutivos.get(i).getApellido());
                        telefono2.setText(ejecutivos.get(i).getTelefono());
                        salario2.setText(Double.toString(ejecutivos.get(i).getSalarioEjecutivo()));
                    }
                }
                nombre2.setEnabled(false);
                apellido2.setEnabled(false);
                telefono2.setEnabled(false);
                salario2.setEnabled(false);

                checkNombre.setSelected(false);
                checkApellido.setSelected(false);
                checkTelefono.setSelected(false);
                checkSalario.setSelected(false);
            }

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_cedulas2ActionPerformed

    private void eliminarEjecutivoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_eliminarEjecutivoActionPerformed
        int resultado = JOptionPane.showConfirmDialog(null, "Esta seguro que desea realizar esta operacion?", "ATENCION", JOptionPane.OK_CANCEL_OPTION);

        if (resultado==0){

            try {
                controlEmpleado = new ControlEmpleado();
                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
                Integer Cedula = Integer.parseInt(cedulas.getSelectedItem().toString());

                for (int i=0;i<ejecutivos.size();i++){
                    if(ejecutivos.get(i).getCedula().equals(Cedula)){
                        boolean result = controlEmpleado.eliminarEmpleado(ejecutivos.get(i));
                        ejecutivos = controlEmpleado.consultarEjecutivos();

                        if (result){
                            cedulas.removeItem(ejecutivos.get(i).getCedula());
                            this.cargarTablaEjecutivos(ejecutivos);
                            this.cargarCedulasEjecutivos();
                            JOptionPane.showMessageDialog(aviso,"El ejecutivo ha sido eliminado con Exito ","Nota", 1);

                            for(int j=0;j<cedulas2.getItemCount();j++){
                                Integer ced = Integer.parseInt(cedulas2.getItemAt(j).toString());
                                if(ced.equals(ejecutivos.get(i).getCedula())){
                                    cedulas2.removeItem(ejecutivos.get(i).getCedula());
                                }
                            }
                        } else{
                            JOptionPane.showMessageDialog(aviso,"El ejecutivo no se pudo eliminar","Nota", 1);
                        }
                    }
                }
            } catch (IOException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            } catch (SQLException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
}//GEN-LAST:event_eliminarEjecutivoActionPerformed

    private void cedulasActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cedulasActionPerformed

        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();

            this.asignarLabelEjecutivo(ejecutivos);

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_cedulasActionPerformed

    private void insertarEjecutivoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_insertarEjecutivoActionPerformed
        try {
            controlEmpleado = new ControlEmpleado();

            if((cedula.getText().equals(""))||(nombre.getText().equals(""))||(apellido.getText().equals(""))||(telefono.getText().equals(""))||(salario.getText().equals(""))){
                JOptionPane.showMessageDialog(aviso,"Debe llenar todos los campos ","Warning", 1);
            }else{

                Integer Cedula = Integer.parseInt(cedula.getText());
                String Nombre = nombre.getText();
                String Apellido = apellido.getText();
                String Telefono = telefono.getText();
                String str = salario.getText();
                double Salario = Double.valueOf(str).doubleValue();

                Empleado empleado = new Empleado(Cedula,Nombre,Apellido,Telefono,"ejecutivo","s",Salario);

                boolean result = controlEmpleado.agregarEmpleado(empleado);
                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();

                if(result){
                    JOptionPane.showMessageDialog(aviso,"El ejecutivo ha sido agregado con Exito","Nota", 1);
                    this.cargarTablaEjecutivos(ejecutivos);
                    this.cargarCedulasEjecutivos();
                    cedulas.addItem(Cedula);
                    cedulas2.addItem(Cedula);
                }else{
                    JOptionPane.showMessageDialog(aviso,"El ejecutivo no pudo ser agregado","Nota", 1);
                }

            }
        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_insertarEjecutivoActionPerformed

    private void limpiarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_limpiarActionPerformed
        cedula.setText("");
        nombre.setText("");
        apellido.setText("");
        telefono.setText("");
        salario.setText("");
}//GEN-LAST:event_limpiarActionPerformed

    private void salarioActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_salarioActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_salarioActionPerformed

    private void apellidoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_apellidoActionPerformed
        // TODO add your handling code here:
}//GEN-LAST:event_apellidoActionPerformed

    private void nombreActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_nombreActionPerformed

}//GEN-LAST:event_nombreActionPerformed

    private void mostrarEjecutivosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mostrarEjecutivosActionPerformed
        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();

            this.cargarTablaEjecutivos(ejecutivos);
            this.cargarCedulasEjecutivos();

        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_mostrarEjecutivosActionPerformed

    private void cargarTablaEjecutivos(List<Empleado> ejecutivos){

        DefaultTableModel dm =  new DefaultTableModel();

            dm.addColumn("Cedula");
            dm.addColumn("Nombre");
            dm.addColumn("Apellido");
            dm.addColumn("Telefono");
            dm.addColumn("Salario");

            for (int i=0;i<ejecutivos.size();i++){
                Vector eje = new Vector();
                eje.addElement(ejecutivos.get(i).getCedula());
                eje.addElement(ejecutivos.get(i).getNombre());
                eje.addElement(ejecutivos.get(i).getApellido());
                eje.addElement(ejecutivos.get(i).getTelefono());
                eje.addElement(ejecutivos.get(i).getSalarioEjecutivo());

                dm.addRow(eje);
            }
            tablaEjecutivos.setModel(dm);
    }

    private void cargarTablaContratados(List<Empleado> contratados){

        DefaultTableModel dm =  new DefaultTableModel();

            dm.addColumn("Cedula");
            dm.addColumn("Nombre");
            dm.addColumn("Apellido");
            dm.addColumn("Telefono");
            dm.addColumn("Cargo");
            dm.addColumn("Costo Hora");

            for (int i=0;i<contratados.size();i++){
                Vector cont = new Vector();
                cont.addElement(contratados.get(i).getCedula());
                cont.addElement(contratados.get(i).getNombre());
                cont.addElement(contratados.get(i).getApellido());
                cont.addElement(contratados.get(i).getTelefono());
                cont.addElement(contratados.get(i).getCargoContratado());
                cont.addElement(contratados.get(i).getCostoHoraContratado());

                dm.addRow(cont);
            }
            tablaContratados.setModel(dm);
    }

    private void cargarTablaEventos(List<Evento> eventos){

        DefaultTableModel dm =  new DefaultTableModel();

            dm.addColumn("Id");
            dm.addColumn("Fecha");
            dm.addColumn("Descripcion");
            dm.addColumn("Hora Inicio");
            dm.addColumn("Hora Fin");
            dm.addColumn("Cedula Ejecutivo");

            for (int i=0;i<eventos.size();i++){
                Vector even = new Vector();
                even.addElement(eventos.get(i).getIdEvento());
                even.addElement(eventos.get(i).getFecha());
                even.addElement(eventos.get(i).getDescripcion());
                even.addElement(eventos.get(i).getHoraInicio());
                even.addElement(eventos.get(i).getHoraFin());
                even.addElement(eventos.get(i).getEjecutivoCedula());

                dm.addRow(even);
            }
            tablaEventos.setModel(dm);
    }

    private void cargarTablaCotizaciones(List<Cotizacion> cotizaciones){

        DefaultTableModel dm =  new DefaultTableModel();

            dm.addColumn("Id");
            dm.addColumn("Estatus");
            dm.addColumn("Fecha");
            dm.addColumn("Color");
            dm.addColumn("Id Evento");
            dm.addColumn("Rif Cliente Compania");
            dm.addColumn("Cedula Cliente Particular");

            for (int i=0;i<cotizaciones.size();i++){
                Vector cot = new Vector();
                cot.addElement(cotizaciones.get(i).getIdCotizacion());
                cot.addElement(cotizaciones.get(i).getEstatus());
                cot.addElement(cotizaciones.get(i).getFecha());
                cot.addElement(cotizaciones.get(i).getColor());
                cot.addElement(cotizaciones.get(i).getEventoIdEvento());
                if(cotizaciones.get(i).getClienteCompaniaRif().equals("")){
                    cot.addElement("--");
                }else{
                    cot.addElement(cotizaciones.get(i).getClienteCompaniaRif());
                }
                if(cotizaciones.get(i).getClienteParticularCedula().equals(0)){
                    cot.addElement("--");
                }else{
                    cot.addElement(cotizaciones.get(i).getClienteParticularCedula());
                }

                dm.addRow(cot);
            }
//            tablaCotizaciones.setModel(dm);
    }

    private void cargarTablaParticulares(List<ClienteParticular> particulares){

        DefaultTableModel dm =  new DefaultTableModel();

            dm.addColumn("Cedula");
            dm.addColumn("Nombre");
            dm.addColumn("Apellido");
            dm.addColumn("Direccion");
            dm.addColumn("Telefono");

            for (int i=0;i<particulares.size();i++){
                Vector part = new Vector();
                part.addElement(particulares.get(i).getCedula());
                part.addElement(particulares.get(i).getNombre());
                part.addElement(particulares.get(i).getApellido());
                part.addElement(particulares.get(i).getDireccion());
                part.addElement(particulares.get(i).getTelefono());

                dm.addRow(part);
            }
//            tablaParticulares.setModel(dm);
    }

    private void cargarTablaCompanias(List<ClienteCompania> companias){

        DefaultTableModel dm =  new DefaultTableModel();

            dm.addColumn("Rif");
            dm.addColumn("Nombre");
            dm.addColumn("Direccion");
            dm.addColumn("Telefono");

            for (int i=0;i<companias.size();i++){
                Vector comp = new Vector();
                comp.addElement(companias.get(i).getRif());
                comp.addElement(companias.get(i).getNombre());
                comp.addElement(companias.get(i).getDireccion());
                comp.addElement(companias.get(i).getTelefono());

                dm.addRow(comp);
            }
//            tablaCompanias.setModel(dm);
    }

    private void cargarTablaAtencionPart(List<EmpleadoClientePart> clientePart){

        DefaultTableModel dm =  new DefaultTableModel();

            dm.addColumn("Cedula Cliente Particular");
            dm.addColumn("Cedula Ejecutivo");

            for (int i=0;i<clientePart.size();i++){
                Vector cli = new Vector();
                cli.addElement(clientePart.get(i).getClienteParticularCedula());
                cli.addElement(clientePart.get(i).getEjecutivoCedula());

                dm.addRow(cli);
            }
//            tablaAtencionPart.setModel(dm);
    }

    private void cargarTablaAtencionComp(List<EmpleadoClienteComp> clienteComp){

        DefaultTableModel dm =  new DefaultTableModel();

            dm.addColumn("Rif Cliente Compania");
            dm.addColumn("Cedula Ejecutivo");

            for (int i=0;i<clienteComp.size();i++){
                Vector cli = new Vector();
                cli.addElement(clienteComp.get(i).getClienteCompaniaRif());
                cli.addElement(clienteComp.get(i).getEjecutivoCedula());

                dm.addRow(cli);
            }
//            tablaAtencionComp.setModel(dm);
    }

    private void cargarCedulasEjecutivos(){

        cedulas.setVisible(false);
        if(cedulas.isPopupVisible()!=true){
           cedulas.removeAllItems();
        }
        cedulas2.setVisible(false);
        if(cedulas2.isPopupVisible()!=true){
           cedulas2.removeAllItems();
        }
            try {
                controlEmpleado = new ControlEmpleado();
                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
                    for (int i=0;i<ejecutivos.size();i++){
                        Integer Cedula = ejecutivos.get(i).getCedula();
                        cedulas.addItem(Cedula);
                        cedulas2.addItem(Cedula);
                        }
            } catch (IOException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            } catch (SQLException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            }
        cedulas.setVisible(true);
        cedulas2.setVisible(true);
}

    private void cargarCedulasEjecutivosPart(){

//        cedulasEjecutivosPart.setVisible(false);
//        if(cedulasEjecutivosPart.isPopupVisible()!=true){
//           cedulasEjecutivosPart.removeAllItems();
//        }
//            try {
//                controlEmpleado = new ControlEmpleado();
//                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
//                    for (int i=0;i<ejecutivos.size();i++){
//                        Integer Cedula = ejecutivos.get(i).getCedula();
//                        cedulasEjecutivosPart.addItem(Cedula);
//                        }
//            } catch (IOException ex) {
//                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//            } catch (SQLException ex) {
//                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//            }
//        cedulasEjecutivosPart.setVisible(true);
}

    private void cargarIdEventoCot(){

//        idEventoCot.setVisible(false);
//        if(idEventoCot.isPopupVisible()!=true){
//           idEventoCot.removeAllItems();
//        }
//            try {
//                controlEvento = new ControlEvento();
//                List<Evento> eventos = controlEvento.consultarEventos();
//                    for (int i=0;i<eventos.size();i++){
//                        Integer Id = eventos.get(i).getIdEvento();
//                        idEventoCot.addItem(Id);
//                        }
//            } catch (IOException ex) {
//                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//            } catch (SQLException ex) {
//                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//            }
//        idEventoCot.setVisible(true);
}

    private void cargarCedulasEjecutivosComp(){
//
//        cedulasEjecutivosComp.setVisible(false);
//        if(cedulasEjecutivosComp.isPopupVisible()!=true){
//           cedulasEjecutivosComp.removeAllItems();
//        }
//            try {
//                controlEmpleado = new ControlEmpleado();
//                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
//                    for (int i=0;i<ejecutivos.size();i++){
//                        Integer Cedula = ejecutivos.get(i).getCedula();
//                        cedulasEjecutivosComp.addItem(Cedula);
//                        }
//            } catch (IOException ex) {
//                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//            } catch (SQLException ex) {
//                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//            }
//        cedulasEjecutivosComp.setVisible(true);
}

    private void cargarCedulasEjecutivosEvento(){

        cedulaEvento.setVisible(false);
        if(cedulaEvento.isPopupVisible()!=true){
           cedulaEvento.removeAllItems();
        }
        cedulaEjec2.setVisible(false);
        if(cedulaEjec2.isPopupVisible()!=true){
           cedulaEjec2.removeAllItems();
        }
            try {
                controlEmpleado = new ControlEmpleado();
                List<Empleado> ejecutivos = controlEmpleado.consultarEjecutivos();
                    for (int i=0;i<ejecutivos.size();i++){
                        Integer Cedula = ejecutivos.get(i).getCedula();
                        cedulaEvento.addItem(Cedula);
                        cedulaEjec2.addItem(Cedula);
                        }
            } catch (IOException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            } catch (SQLException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            }
        cedulaEvento.setVisible(true);
        cedulaEjec2.setVisible(true);
}

    private void cargarIdEventos(){

        idEventos.setVisible(false);
        if(idEventos.isPopupVisible()!=true){
           idEventos.removeAllItems();
        }
        idEventos2.setVisible(false);
        if(idEventos2.isPopupVisible()!=true){
           idEventos2.removeAllItems();
        }
            try {
                controlEvento = new ControlEvento();
                List<Evento> eventos = controlEvento.consultarEventos();
                    for (int i=0;i<eventos.size();i++){
                        Integer id = eventos.get(i).getIdEvento();
                        idEventos.addItem(id);
                        idEventos2.addItem(id);
                        }
            } catch (IOException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            } catch (SQLException ex) {
                Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
            }
        idEventos.setVisible(true);
        idEventos2.setVisible(true);
}

    private void asignarLabelEjecutivo(List<Empleado> ejecutivos){

        if(cedulas.getItemCount()!=0){
            Integer Cedula = Integer.parseInt(cedulas.getSelectedItem().toString());

            for (int i=0;i<ejecutivos.size();i++){

                if(ejecutivos.get(i).getCedula().equals(Cedula)){
                    nombreEjecutivo.setText(ejecutivos.get(i).getNombre());
                    apellidoEjecutivo.setText(ejecutivos.get(i).getApellido());
                    telefonoEjecutivo.setText(ejecutivos.get(i).getTelefono());
                    salarioEjecutivo.setText(Double.toString(ejecutivos.get(i).getSalarioEjecutivo()));
                }
            }
       }
}

    private void asignarEtiquetaEjecutivo(List<Empleado> ejecutivos){
//        if(cedulasEjecutivosPart.getItemCount()!=0){
//            Integer Cedula = Integer.parseInt(cedulasEjecutivosPart.getSelectedItem().toString());
//
//            for (int i=0;i<ejecutivos.size();i++){
//                if(ejecutivos.get(i).getCedula().equals(Cedula)){
//                    cedulasEjecutivosPart.setToolTipText(ejecutivos.get(i).getNombre()+" "+ejecutivos.get(i).getApellido());
//                }
//            }
//       }
}

    private void asignarEtiquetaEjecutivoComp(List<Empleado> ejecutivos){
//        if(cedulasEjecutivosComp.getItemCount()!=0){
//            Integer Cedula = Integer.parseInt(cedulasEjecutivosComp.getSelectedItem().toString());
//
//            for (int i=0;i<ejecutivos.size();i++){
//                if(ejecutivos.get(i).getCedula().equals(Cedula)){
//                    cedulasEjecutivosComp.setToolTipText(ejecutivos.get(i).getNombre()+" "+ejecutivos.get(i).getApellido());
//                }
//            }
//       }
}

    private void asignarEtiquetaEvento(List<Evento> eventos){
//        if(idEventoCot.getItemCount()!=0){
//            Integer Id = Integer.parseInt(idEventoCot.getSelectedItem().toString());
//
//            for (int i=0;i<eventos.size();i++){
//                if(eventos.get(i).getIdEvento().equals(Id)){
//                    idEventoCot.setToolTipText(eventos.get(i).getDescripcion()+" "+eventos.get(i).getFecha().toString());
//                }
//            }
//       }
}

    private void asignarEtiquetaClienteComp(List<ClienteCompania> companias){
//        if(rifCompaniaCot.getItemCount()!=0){
//            String Rif = rifCompaniaCot.getSelectedItem().toString();
//
//            for (int i=0;i<companias.size();i++){
//                if(companias.get(i).getRif().equals(Rif)){
//                    rifCompaniaCot.setToolTipText(companias.get(i).getNombre());
//                }
//            }
//       }
}

    private void asignarEtiquetaClientePart(List<ClienteParticular> particulares){
//        if(cedulaParticularCot.getItemCount()!=0){
//            Integer Cedula = Integer.parseInt(cedulaParticularCot.getSelectedItem().toString());
//
//            for (int i=0;i<particulares.size();i++){
//                if(particulares.get(i).getCedula().equals(Cedula)){
//                    cedulaParticularCot.setToolTipText(particulares.get(i).getNombre()+" "+particulares.get(i).getApellido());
//                }
//            }
//       }
}

    private void asignarLabelContratado(List<Empleado>contratados){

        if(cedulasC.getItemCount()!=0){
           Integer Cedula = Integer.parseInt(cedulasC.getSelectedItem().toString());

           for (int i=0;i<contratados.size();i++){

               if(contratados.get(i).getCedula().equals(Cedula)){
                   nombreContratado.setText(contratados.get(i).getNombre());
                   apellidoContratado.setText(contratados.get(i).getApellido());
                   telefonoContratado.setText(contratados.get(i).getTelefono());
                   cargoContratado.setText(contratados.get(i).getCargoContratado());
                   costoContratado.setText(Double.toString(contratados.get(i).getCostoHoraContratado()));
               }
            }
        }
}

    private void asignarLabelParticulares(List<ClienteParticular> particulares){

//        if(cedulasParticulares.getItemCount()!=0){
//            Integer Cedula = Integer.parseInt(cedulasParticulares.getSelectedItem().toString());
//
//            for (int i=0;i<particulares.size();i++){
//
//                if(particulares.get(i).getCedula().equals(Cedula)){
//                    nombrePartLabel.setText(particulares.get(i).getNombre());
//                    apellidoPartLabel.setText(particulares.get(i).getApellido());
//                    direccionPartLabel.setText(particulares.get(i).getDireccion());
//                    telefonoPartLabel.setText(particulares.get(i).getTelefono());
//                }
//            }
//       }
}

    private void asignarLabelCompanias(List<ClienteCompania> companias){

//        if(rifsCompanias.getItemCount()!=0){
//            String Rif = rifsCompanias.getSelectedItem().toString();
//
//            for (int i=0;i<companias.size();i++){
//
//                if(companias.get(i).getRif().equals(Rif)){
//                    nombreCompLabel.setText(companias.get(i).getNombre());
//                    direccionComp.setText(companias.get(i).getDireccion());
//                    telefonoCompLabel.setText(companias.get(i).getTelefono());
//                }
//            }
//       }
}

private void asignarLabelEventos(List<Evento> eventos){

    if(idEventos.getItemCount()!=0){
       Integer id = Integer.parseInt(idEventos.getSelectedItem().toString());

       for (int i=0;i<eventos.size();i++){

           if(eventos.get(i).getIdEvento().equals(id)){
               fechaLabel.setText(eventos.get(i).getFecha().toString());
               descripcionLabel.setText(eventos.get(i).getDescripcion());
               horaInicioLabel.setText(eventos.get(i).getHoraInicio().toString());
               horaFinLabel.setText(eventos.get(i).getHoraFin().toString());
               cedEventoLabel.setText(eventos.get(i).getEjecutivoCedula().toString());
           }
        }
    }
}

private void asignarLabelCotizaciones(List<Cotizacion> cotizaciones){

//    if(idsCotizaciones.getItemCount()!=0){
//       Integer id = Integer.parseInt(idsCotizaciones.getSelectedItem().toString());
//
//       for (int i=0;i<cotizaciones.size();i++){
//
//           if(cotizaciones.get(i).getIdCotizacion().equals(id)){
//               if(cotizaciones.get(i).getEstatus().equals("I")){
//                   estatusCotLabel.setText("Inicial");
//               }
//               if(cotizaciones.get(i).getEstatus().equals("A")){
//                   estatusCotLabel.setText("Aprobado");
//               }
//               if(cotizaciones.get(i).getEstatus().equals("R")){
//                   estatusCotLabel.setText("Rechazado");
//               }
//               fechaCotLabel.setText(cotizaciones.get(i).getFecha().toString());
//               colorCotLabel.setText(cotizaciones.get(i).getColor());
//               idEventoCotLabel.setText(cotizaciones.get(i).getEventoIdEvento().toString());
//               if(cotizaciones.get(i).getClienteCompaniaRif().equals("")){
//                   rifCompCotLabel.setText("--");
//               }else{
//                    rifCompCotLabel.setText(cotizaciones.get(i).getClienteCompaniaRif());
//               }
//               if(cotizaciones.get(i).getClienteParticularCedula().equals(0)){
//                   cedPartCotLabel.setText("--");
//               }else{
//                   cedPartCotLabel.setText(cotizaciones.get(i).getClienteParticularCedula().toString());
//               }
//           }
//        }
//    }
}

private void cargarCedulasContratados(){
    cedulasC.setVisible(false);
    if(cedulasC.isPopupVisible()!=true){
            cedulasC.removeAllItems();
    }
    cedulasC2.setVisible(false);
    if(cedulasC2.isPopupVisible()!=true){
            cedulasC2.removeAllItems();
    }
        try {
            controlEmpleado = new ControlEmpleado();
            List<Empleado> contratados = controlEmpleado.consultarContratados();
                for (int i=0;i<contratados.size();i++){
                    Integer Cedula = contratados.get(i).getCedula();
                    cedulasC.addItem(Cedula);
                    cedulasC2.addItem(Cedula);
                    }
        } catch (IOException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
        }
    cedulasC.setVisible(true);
    cedulasC2.setVisible(true);
}

private void cargarCedulasParticulares(){

//    cedulasParticulares.setVisible(false);
//    if(cedulasParticulares.isPopupVisible()!=true){
//            cedulasParticulares.removeAllItems();
//    }
//    cedulasParticulares2.setVisible(false);
//    if(cedulasParticulares2.isPopupVisible()!=true){
//            cedulasParticulares2.removeAllItems();
//    }
//        try {
//            controlClientePart = new ControlClienteParticular();
//            List<ClienteParticular> particulares = controlClientePart.consultarClienteParticular();
//                for (int i=0;i<particulares.size();i++){
//                    Integer Cedula = particulares.get(i).getCedula();
//                    cedulasParticulares.addItem(Cedula);
//                    cedulasParticulares2.addItem(Cedula);
//                    }
//        } catch (IOException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        } catch (SQLException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        }
//    cedulasParticulares.setVisible(true);
//    cedulasParticulares2.setVisible(true);
}

private void cargarCedulasParticularesCot(){

//    cedulaParticularCot.setVisible(false);
//    if(cedulaParticularCot.isPopupVisible()!=true){
//            cedulaParticularCot.removeAllItems();
//    }
//        try {
//            controlClientePart = new ControlClienteParticular();
//            List<ClienteParticular> particulares = controlClientePart.consultarClienteParticular();
//                for (int i=0;i<particulares.size();i++){
//                    Integer Cedula = particulares.get(i).getCedula();
//                    cedulaParticularCot.addItem(Cedula);
//                    }
//        } catch (IOException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        } catch (SQLException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        }
//    cedulaParticularCot.setVisible(true);
}

private void cargarRifsCompanias(){

//    rifsCompanias.setVisible(false);
//    if(rifsCompanias.isPopupVisible()!=true){
//            rifsCompanias.removeAllItems();
//    }
//    rifsCompanias2.setVisible(false);
//    if(rifsCompanias2.isPopupVisible()!=true){
//            rifsCompanias2.removeAllItems();
//    }
//        try {
//            controlClienteComp = new ControlClienteCompania();
//            List<ClienteCompania> companias = controlClienteComp.consultarClienteCompania();
//                for (int i=0;i<companias.size();i++){
//                    String Rif = companias.get(i).getRif();
//                    rifsCompanias.addItem(Rif);
//                    rifsCompanias2.addItem(Rif);
//                    }
//        } catch (IOException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        } catch (SQLException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        }
//    rifsCompanias.setVisible(true);
//    rifsCompanias2.setVisible(true);
}

private void cargarRifsCompaniasCot(){
//    rifCompaniaCot.setVisible(false);
//    if(rifCompaniaCot.isPopupVisible()!=true){
//            rifCompaniaCot.removeAllItems();
//    }
//
//        try {
//            controlClienteComp = new ControlClienteCompania();
//            List<ClienteCompania> companias = controlClienteComp.consultarClienteCompania();
//                for (int i=0;i<companias.size();i++){
//                    String Rif = companias.get(i).getRif();
//                    rifCompaniaCot.addItem(Rif);
//                    }
//        } catch (IOException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        } catch (SQLException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        }
//    rifCompaniaCot.setVisible(true);
}

private void cargarIdsCotizaciones(){

//    idsCotizaciones.setVisible(false);
//    if(idsCotizaciones.isPopupVisible()!=true){
//            idsCotizaciones.removeAllItems();
//    }
//    idsCotizaciones2.setVisible(false);
//    if(idsCotizaciones2.isPopupVisible()!=true){
//            idsCotizaciones2.removeAllItems();
//    }
//        try {
//            controlCotizacion = new ControlCotizacion();
//            List<Cotizacion> cotizaciones = controlCotizacion.consultarCotizaciones();
//                for (int i=0;i<cotizaciones.size();i++){
//                    Integer Id = cotizaciones.get(i).getIdCotizacion();
//                    idsCotizaciones.addItem(Id);
//                    idsCotizaciones2.addItem(Id);
//                    }
//        } catch (IOException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        } catch (SQLException ex) {
//            Logger.getLogger(insumos_inventarios.class.getName()).log(Level.SEVERE, null, ex);
//        }
//    idsCotizaciones.setVisible(true);
//    idsCotizaciones2.setVisible(true);
}

    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new insumos_inventarios().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton ModificarEvento;
    private javax.swing.JMenuItem acercaDe;
    private com.toedter.calendar.JYearChooser ano;
    private com.toedter.calendar.JYearChooser anoEve2;
    private javax.swing.JTextField apellido;
    private javax.swing.JTextField apellido2;
    private javax.swing.JTextField apellidoC;
    private javax.swing.JTextField apellidoC2;
    private javax.swing.JLabel apellidoContratado;
    private javax.swing.JLabel apellidoEjecutivo;
    private javax.swing.JMenu archivo;
    private javax.swing.ButtonGroup buttonGroup1;
    private javax.swing.JTextField cargo;
    private javax.swing.JTextField cargo2;
    private javax.swing.JLabel cargoContratado;
    private javax.swing.JLabel cedEventoLabel;
    private javax.swing.JTextField cedula;
    private javax.swing.JTextField cedulaC;
    private javax.swing.JComboBox cedulaEjec2;
    private javax.swing.JComboBox cedulaEvento;
    private javax.swing.JComboBox cedulas;
    private javax.swing.JComboBox cedulas2;
    private javax.swing.JComboBox cedulasC;
    private javax.swing.JComboBox cedulasC2;
    private javax.swing.JCheckBox checkApellido;
    private javax.swing.JCheckBox checkApellidoC;
    private javax.swing.JCheckBox checkCargo;
    private javax.swing.JCheckBox checkCedulaE;
    private javax.swing.JCheckBox checkCosto;
    private javax.swing.JCheckBox checkDescripcionE;
    private javax.swing.JCheckBox checkFechaE;
    private javax.swing.JCheckBox checkHoraFinE;
    private javax.swing.JCheckBox checkHoraInicioE;
    private javax.swing.JCheckBox checkNombre;
    private javax.swing.JCheckBox checkNombreC;
    private javax.swing.JCheckBox checkSalario;
    private javax.swing.JCheckBox checkTelefono;
    private javax.swing.JCheckBox checkTelefonoC;
    private javax.swing.JTextField costo;
    private javax.swing.JTextField costo2;
    private javax.swing.JLabel costoContratado;
    private javax.swing.JTextField descripcion2;
    private javax.swing.JTextField descripcionEvento;
    private javax.swing.JLabel descripcionLabel;
    private javax.swing.JComboBox dia;
    private javax.swing.JComboBox diaEve2;
    private javax.swing.JButton eliminarEjecutivo;
    private javax.swing.JButton eliminarEjecutivo1;
    private javax.swing.JButton eliminarEvento;
    private javax.swing.JMenuItem exit;
    private javax.swing.JLabel fechaLabel;
    private javax.swing.JTextField horaFin2;
    private javax.swing.JComboBox horaFinEvento;
    private javax.swing.JLabel horaFinLabel;
    private javax.swing.JTextField horaInicio2;
    private javax.swing.JComboBox horaInicioEvento;
    private javax.swing.JLabel horaInicioLabel;
    private javax.swing.JComboBox idEventos;
    private javax.swing.JComboBox idEventos2;
    private javax.swing.JMenuItem informacionSistema;
    private javax.swing.JButton insertarEjecutivo;
    private javax.swing.JButton insertarEjecutivo1;
    private javax.swing.JButton insertarEjecutivo2;
    private javax.swing.JButton insertarEjecutivo3;
    private javax.swing.JButton insertarEjecutivo4;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel25;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel27;
    private javax.swing.JLabel jLabel28;
    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel33;
    private javax.swing.JLabel jLabel34;
    private javax.swing.JLabel jLabel35;
    private javax.swing.JLabel jLabel36;
    private javax.swing.JLabel jLabel37;
    private javax.swing.JLabel jLabel38;
    private javax.swing.JLabel jLabel39;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel40;
    private javax.swing.JLabel jLabel42;
    private javax.swing.JLabel jLabel43;
    private javax.swing.JLabel jLabel44;
    private javax.swing.JLabel jLabel45;
    private javax.swing.JLabel jLabel46;
    private javax.swing.JLabel jLabel47;
    private javax.swing.JLabel jLabel48;
    private javax.swing.JLabel jLabel49;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel50;
    private javax.swing.JLabel jLabel51;
    private javax.swing.JLabel jLabel52;
    private javax.swing.JLabel jLabel53;
    private javax.swing.JLabel jLabel54;
    private javax.swing.JLabel jLabel55;
    private javax.swing.JLabel jLabel56;
    private javax.swing.JLabel jLabel57;
    private javax.swing.JLabel jLabel58;
    private javax.swing.JLabel jLabel59;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel60;
    private javax.swing.JLabel jLabel61;
    private javax.swing.JLabel jLabel62;
    private javax.swing.JLabel jLabel63;
    private javax.swing.JLabel jLabel64;
    private javax.swing.JLabel jLabel65;
    private javax.swing.JLabel jLabel66;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel10;
    private javax.swing.JPanel jPanel11;
    private javax.swing.JPanel jPanel12;
    private javax.swing.JPanel jPanel13;
    private javax.swing.JPanel jPanel14;
    private javax.swing.JPanel jPanel15;
    private javax.swing.JPanel jPanel16;
    private javax.swing.JPanel jPanel17;
    private javax.swing.JPanel jPanel18;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JPanel jPanel9;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JSeparator jSeparator1;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JButton limpiar;
    private javax.swing.JButton limpiar1;
    private javax.swing.JButton limpiar4;
    private com.toedter.calendar.JMonthChooser mes;
    private com.toedter.calendar.JMonthChooser mesEve2;
    private javax.swing.JButton mostrarContratados;
    private javax.swing.JButton mostrarContratados1;
    private javax.swing.JButton mostrarEjecutivos;
    private javax.swing.JTextField nombre;
    private javax.swing.JTextField nombre2;
    private javax.swing.JTextField nombreC;
    private javax.swing.JTextField nombreC2;
    private javax.swing.JLabel nombreContratado;
    private javax.swing.JLabel nombreEjecutivo;
    private javax.swing.JMenuItem nuevaCotizacion;
    private javax.swing.JTextField salario;
    private javax.swing.JTextField salario2;
    private javax.swing.JLabel salarioEjecutivo;
    private javax.swing.JButton salir;
    private javax.swing.JTable tablaContratados;
    private javax.swing.JTable tablaEjecutivos;
    private javax.swing.JTable tablaEventos;
    private javax.swing.JTextField telefono;
    private javax.swing.JTextField telefono2;
    private javax.swing.JTextField telefonoC;
    private javax.swing.JTextField telefonoC2;
    private javax.swing.JLabel telefonoContratado;
    private javax.swing.JLabel telefonoEjecutivo;
    // End of variables declaration//GEN-END:variables

}
